DSXchange

Hi, I am in a situation to not able to login to datastage designer or director client from windows. Gives an error "failed to authenticate the current user against the selected Services Tier". However I am able to login through web console and manager client. Also I am able to login to the...

Hi, I am using concatenated result of 5 columns (different datatypes) to calculate the checksum value. The problem is even though the concatenated string of the 5 columns is different, it is generating the same checksum value. Is there any restriction on the length of string (input value) to generat...

Hi, I have a problem for which I was unable to find some solution from the search. Posting it here. I have an exiting job with xml unpack stage to read the xml file and output data to some text files. Now there is a change in xsd from the source, change of namespace and additional elements Earlier t...

Thank you all for the replies. It has been identified that the copy book definition was outdated and I am waiting for the revised copy book
And hope it does not create any issues

Tried creating a new record defining a single column as character type equal to the length of the record but of no result

Hi, I am receiving zipped binary (EBCDIC))complex flat file This is a fixed width file and contains a header record Could you please suggest how an I filter the header record in the complex flat file stage At the job level the file is being unzipped and on running the job, the job is failing with th...

Here in the organization the execution of jobs are scheduled by a scheduling agent and hence cannot pass arguments dynamically.

As for the current situation, would validate for each failure instead of complete automization

Hi Mike, The reason for CRASHED was because of an unplanned restart of the server and not because of resource issue or design issue. As suggested I would implement the manual intervention by email or by monitoring. The query still I have in my mind is why is the job restarting again automatically af...

Personally, I would never attempt to automate the restart of a STOPPED or CRASHED job. These are unexpected ways for a job to end. I would require human intervention to perform analysis and take corrective action based on the analysis. Had to automate as per the project requirement. Would you sugge...

It shouldn't restart, complete, and then run it all over again.... unless perhaps (just a guess) if there were multiple scripts or restart commands issued at the same time with the -wait option. I would want to try to reproduce that behavior, because it sounds like an unusual problem. It is a singl...

To stop the engine is difficult as there are other projects that are running on this server. $HOME_DS/bin/dsjob -jobinfo PROJECT SEQUENCE_NAME In the script logic validating if the status of the job is FAILED/STOPPED/CRASHED and if the job is restartable(check pointed sequence) In my case the sequen...

Hello All, I have below requirement to validate the status of a job/sequence before running the job from command line using dsjob $HOME_DS/bin/dsjob -jobinfo PROJECT SEQUENCE_NAME Validate the status of the job for the status of STOPPED/FAILED/CRASHED/ and reset the job in case encountered any of th...

I have to rearrange data from an activities table to have an activity and its consecutive activity in a single row from historical data which has each activity recorded (1 record for each activity) I have data similar to below in the history table id,app_id,task 1,1234,entry 2,3245,entry 3,1234,acce...

Agreed Chulett

In case you need the output in the format you mentioned, your code would suffice.
Note that your output column should be of date datatype