DSXchange

Oh, and the hardware requirements are greater. Particularly memory and disk space.

7.5x2 is for Windows only, and does not have the DB2 Enterprise stage.

7.5.2 is for all platforms and does have the DB2 Enterprise stage. However this version does not support compiling and running jobs on Windows platforms; only designing them.

What (exact) version is your friend running?

Best practice is never to use network drives for resource scratchdisk, and to avoid doing so for resource disk.

This has to do with a number of things all of which will be too greatly constrained by network bandwidth.

Of course. You could use an echo command redirecting its output (via DSExecute), or you could use the WriteSeq statement (which implies OpenSeq and CloseSeq) in your subroutine.

Is your job parameter of type String?

Post your actual expression used when setting the job parameter. You may need to remove @FM characters from the command output.

Welcome aboard.

What is different between the environments where it works and the environment where it does not work?

("Nothing" is not the correct answer. However the correct answer may lie outside of DataStage. You need to be the detective.)

Make sure you have the correct field delimiter character and the correct quote character specified.

What is the data type of BALANCE_ID ?

Imagine we're processing the date 2007-10-04. The year is 2007, the month is 10, and we require 2071001 as the result. The "2" is the century designator. cast(YR as INTEGER)-1900)*10000 returns (2007-1900) * 10000, or 2070000 cast(Mnth as INTEGER)*100 returns (10 * 100), or 1000 cast('01' as INTEGER...

Learn what the highest date that can legally be represented in your DB2 instance is, and check that no later date is included in your data. Be wary of the format of the date also, for example don't supply mmddyyyy if yyyy-mm-dd is expected.

Not from dsjob (apart from reading the log). There is a C language API (dscapi) that is effectively the same as the BASIC API (dsapi) - you can use the functions in that. This is the API that dsjob uses.