DSXchange

Hi, I read one presentation, which is briefing about Datastage at a Higher level. In "Compilation Notes", they wrote the following points. On clustered / GRID environments: Share the project directory to share Transformers (Must be identical mount point across servers) Or set $APT_COPY_TRA...

Hi all,
my source is db2 and target is flat file,loading the data using teansformer stage.here i need to convert the RGB value into hexadecimal value.please let me know,how can i convert using transformer stage.please tell me briefly.

Hi Chulett, Thanks for you info. It completed my task. I implemented it in following way. /apps/Ascential/DataStage/DSEngine/bin/dsjob -jobinfo TTE TTE_SEQ_RPTDB >Job_Restart.txt Job_Restart=`cat Job_Restart.txt | grep "Job Restartable" | awk -F ":" '{print $2}' | sed s'/ //g'` i...

Hi,
Thanks for your reply, Here i am referring to sequencer job, not the individual job. can you please tell me a way of differentiating sequencer job status as "Aborted/Restartable" (Restartable sequencer) to "Aborted"(Normal Sequencer)

Hi, I had ticked the check box "Add check points so that the job is restartable" in a sequencer Job properties. So the Job is able to restart from the point where it got aborted. here we have a generic script for running datastage job. After running the datastage job, we are capturing the ...

Hi, I have a sequencer where a Job activity stage follows a command activity stage. I want to return a value calculated in the shell script(command activity stage) to the job(Job activity) stage as one of the parameter in Job. I tried to return value from the shell script. but it did not work out. c...

Hi, I want to sort my data based on two columns namely "snumber" and "sdigit". I tried by giving the following options in sort specification 1) snumber, sdigit asc 2) snumber asc, sdigit asc 3) snumber asc [, sdigit asc] but none of the above trails worked, and i am getting "...

Hi, my datastage job contains two aggregators, output of the two aggregators are joined in a join stage with 'innerjoin' mode. when i run my job untill this join stage, it runs fine. i kept one transformer stage where i am calculating so many variables based on variables RATESAVG_1,RATESAVG_2,RATESA...

Hi, i am working on a datastage job. After i started running it, i came to know that i did a mistake in my job. so i tried to stop the job by clicking stop button in director, but as the job is still running, i clicked the stop button in director 2 more times. After that i am not able to compile,run...

yes, i created the dataset at end of the job. before the dataset a sort stage is used. when i give another name for the dataset, it is working fine. so i tried to delete the existing dataset by using dataset management in director, it is telling the same fatal errors i mentioned above and failed to ...

Hi, i got the following two fatal errors in my job 1)main_program: The file identified as '/work/temp/dataset.ds' is not an ORCHESTRATE Data Set descriptor. 2)work/temp/dataset.ds: Data set initialization for "work/temp/dataset.ds":Output-file data set error: work/temp/dataset.ds. i got on...

thank you Priyadarshi Kunal, with your advice i solved the problem

Hi, i got the following warning regarding a lookup stage. Warning :Med_Paid_lkp,0: Ignoring duplicate entry at table record 2; no further warnings will be issued for this table Lookup stage is having a main link and reference link among which the records in main link are unique with respect to the l...