DSXchange

Dropping a BASIC transformer into a Parallel job will cripple your performance, as it will run sequentially on a single node (the conductor node) regardless of the degree of parallelism in use. That is not necessarily true. This stage type can run on multiple nodes in an SMP environment and (theore...

The Planning, Installation and Configuration Guide is available online, all 503 pages of it.

That's because you haven't coded for it!

Look for an option called Preserve Type. It exists in version 7.5.2; not sure about earlier versions. (7.5.2 is not the same as 7.5x2 but check anyway.)

DataStage was expecting a date. A field containing all blanks is not a valid date format.

Please advise how this issue was resolved.

Posting the same question in multiple fora will not gain you anything, and annoys the natives.

DB2Connect is THE client software for DB2 cross-platform access.

What are the input and output values? In particular what is the hex value, and can the input contain nulls?

The decimal number is not stored with the trailing zeroes, it is only displayed with them. You can not get rid of them in the View Data dialog. If you want to get rid of them into a text file, declare the data type as VarChar, then Trim() will work.

I suspect that these identifiers refer to server routines called from another server routine, but one in which you have failed to specify that they are actually functions using DEFFUN declarations. Either this is called from a BASIC Transformer stage or it is a server Transformer (either in a server...

We know that. Repeating it does not help. What IS the illegal character?

You've missed a test on SAddHours being less than zero. In this case add 24 hours to the time and subtract 1 from the date. I'm assuming that SHours will never be more than +24 or less than -24, otherwise you may need to introduce a loop to adjust the date.

There's no rollback - job 1 will have executed a COMMIT. The usual approach is to mark all loads with, say, a unique run number or timestamp. Then you can create "rollback" jobs that delete rows that have been inserted with this identifier. If you need to "rollback" updates, then...