DSXchange

What would be the answer for this, I tried searching.

You crack me up PhilHibbs.

I do the same at my current site. I use something like this select NEXT VALUE FOR sequenceowner.sequenceobjectname, 'X' from sysibm.sysdummy1 The 'X' becomes my dummy key to do a lookup on and get the key. This keeps the sequence object in sync as well. Now since this is a sparse lookup it will beco...

Run the entire job on single node and see if its sequential coupled with parallel is causing issues.

Single node perhaps

Any before job routine at work here?

At this point, with all the obvious reasons discarded, get in touch with IBM.

Do what Eric suggested.

If Isnull() then zero else whatever.

Search is your friend
viewtopic.php?t=142985&highlight=group+number

Thanks dsusersaj. Some of the other pics on 500px are just amazing. People have some real talent.

Make sure you are passing the right config file to all the jobs.

Count the number of delimiters, set that number as your counter in the loop and duplicate the rest with a new line character between your rows.

You want loop and duplication. What version of datastage are you on?

In DB2 it depends how the DBA has set it. There are conditional values on inserts as well.
Test it out as Craig mentioned. Drop the records in a dataset or flat file and see what the values are. If it shows up null there then there is something on the database side.