DSXchange

You have many methods.
You can use filter command and read Head -1 and the file name.
And you can specify /dev/null in the File name option.
Or you can perform the same in Before job subroutine.
Head -1 filename > Filename2.txt
And read the Filename2.txt
Or simply use Head Stage.

Just click on add of the right side in the current page.

Hi Search for Check Point restart. You can also find it documented. The check option available in job property. If this ain't enabled, whenever you rerun the sequence, you would end up run all the job from the scratch. Also Include 'Reset if required and Rerun' so that you can restart from the point...

naveen, it is obvious that Job Controls are more flexible than Job Sequences! You can't dynamically set parameters to a job activity, maintenance is harder when you have to add a parameter to all the jobs, etc... Still parameter values can be passed dynamically from shell scripts using dsjob -param...

You can find a FAQ regarding SQL error code for failed upsert.

You can also use

from TCL. You can find most of the error codes but not all.
This uses six-digit keys, so to find 81002 your query would need to add a leading zero, and use a character string.

But most likely and in most of the cases (Atlest as for as I have seen) the DataStage is to load into DataBase according to its requirement or buisness nees.

Error codes may not be always the same acorss versions. But you can search for it Like the list of current Job Control Error codes. Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings Equ DSJS.RUNWA...

#@$%@#$%^&*$^*!@#$@#$^%^*(%^(&*%^&*
In English,
What is that you want to achieve through Job Sequence which you think its not feasible.

In general, DB2 accepts 2 format.
DD-MM-YYYY HH:NN:SS.000000
Or
DD-MM-YYYY-HH.NN.SS.000000

Hi,
Welcome Aboard :D
$PROJDEF picks the value up from what was set in the Administrator client.
$ENV picks the value up from the executing user's environment.

Not sure about this. Pls correct me if Iam wrong. To get the new users be in part of the ds group and to get it effective member to use DS Server, shoulnt the DS Server be restarted. Or should the user need to source the dsenv and try.

Hi,
In such case, dont check for all the column to be same, rather just check for the few column which you sure about unique when compared to the other group. And concatinate the POS column.

What is the key that you have mentioned in the internal sort and the key for remove duplicate. Make sure both are in the same order.
You can acheive the same via sort stage also.

I afraid, if Iam not clear. As i mentioned the libgciudt6.so is in $DSHOME/lib and the same has been referred to the search path.