DSXchange

You're not necesarily going wrong. DataStage is simply letting you know that there are dupllicates, and what it's doing with them (ignoring them, so that you only get one row returned, from a reference input link for example). You can use a message handler to demote the warning message to informatio...

OpenSeq ought not to work at all in a parallel job or routine.

Indeed, a single Transformer stage is likely to be more efficient than two consecutive Modify stages.

There's a lot more information in the error message about exactly where the error was caught, which will narrow your field of investigation.

It may be that the DateGenericToTimestamp routine was invoked indirectly, that is from some other routine that is invoked from the job.

The job finishes processing rows into the two files. Then you can invoke a UNIX command cat to append the contents of the trailer file to the detail file, or both into a third file. You can do this via an Execute Command activity in the job sequence that is controlling the job, since parallel jobs d...

When using NEXTVAL in the INSERT statement you don't get the value back. That's the whole point. It's faster.

If the column definition on the DB2 table is some kind of integer, the leading zeroes are redundant and therefore not stored.
If the column definition specifies Char, then leading zeroes can be kept.

That too.

Compile in development. Test in test. Promote with Version Control.

ErrCode = DSSetParam(hJob, ParamName, ScrOutput)

Isn't the date suppose to be in a particular format for the ICONV/OCONV to work??? ICONV is extremely flexible. Sometimes just "D" is enough, if the date format matches your locale. Otherwise just D followed by date component indicators (for example "DYMD") suffices. With OCONV you can be as specif...

We all have small lapses.

LONGNAMES should be set to ON during installation and never be changed. It's task (if OFF) is to allow old UNIX systems' file name size limit of 14 characters to be honoured. If you try to create a hashed file whose name is more than 14 characters long, and LONGNAMES OFF is in effect, then what will...

KPReddy wrote: But i found this function in the server jobs documentation.

Where?

KPReddy wrote:If not is there any other way to get output links of a stage.

DSGetStageInfo(hJob, DSJ.LINKLIST)

Lose the Version Control tags (^1_1) in DEFFUN statements.