DSXchange

hi I am having source as db2 udb stage and target as db2 udb stage, with database as db2. in source i am having a column with metadata as timestamp 26, scale 6, trying to convert it into a target column with metadata date 10. its gives me following error "Value treated as NULL Attempt to conver...

Hi, I am using crontab to schedule my datastage job. My crontab file looks like 30 20 7 7 1 /home/temp1 > /home/temp1.log And temp1 file contains: cd /home/dsadm/Ascential/DataStage/DSEngine/bin dsjob -run -mode NORMAL -wait -jobstatus ProjectName Job_Name but after scheduling the crontab, its givin...

hi

i wann to set the trigger condition as if 1 or 0 is present in the output string the it should carry on.

expression type is ReturnValue (Condition) and i tried as contains (0,1) and in (0,1) within expression, but it is giving error

Return value is "abcd efgh 1"

This time also I restarted the Datastage server, & now its running fine. The problem is that after warning (Job control process (pid 2187352) has failed)), the job is still running, only thing is I am getting message in director (in green) that "Job Aborted". while running through comm...

Hi, While running a job I am getting following message (warning) "Job control process (pid 553122) has failed" & after that I am getting message as "Job Aborted". This happened earlier also, then we restarted the server & it was running fine. But today again its happening...

Thanks, I got the concept :D

Thanks Clauss,
Yes the reason behind is the previous status of sequence was aborted I used the command to reset its status. And now its running fine.
Thanks,

Hi, When I stop the datastage server ($DSHOME/bin uv -admin -stop) & again try to restart the server ($DSHOME/bin uv -admin -start). I am not able to start the server in single go. I have to stop & then start multiple times, to restart the server. Please help me in getting this problem resol...

Hi, I am running sequence from command line of Unix. The sequence run properly when I compile the sequence & the included jobs in that sequence. But If I run the sequence without compiling it then I get the error "Job/Sequence is not in runnable state". I would like to know whether is ...

i have stored the value required in a hash file , in job1. now can i allocate this value to any varible ,or can i take this value as input in any routine, so as i can call that routine for getting the value stored in datastage

hi

i have some computed value that i am getting in job1, i want to store this value in a enviroment variable and in job1 only after getting computed , then in job2 i want to use the same value of env varible

hi

can anyone plz tell me to default ENVIROMENT VARIABLE through job without storing that value into any file . or is there any way to do this using routine

thanks

can i get a way to bring the warning message i.e. displayed in director to job(target file is seq) by using some routine

i added one column in target, which is a seq file , and with the help of DSStageLastErr function , its not giving any information as why this row is rejected , it just informs that row is rejected. i wann information as if it is getting rejected because of key column being null or say datetime overf...

hi, i wann a way to give message to user what the row is getting rejected