DSXchange

"this command"? What command?

Search in on-line help for DSExecute subroutine.

More data than the field width allows for.

Difference stage
Compare stage
Change Capture stage

There is a chapter on each in the Parallel Job Developer's Guide which I do not propose to reproduce here.

0.5

For the rest you can Search on DSXchange (where this answer has been given several times already) or the IBM web site.

A suite of job sequences is the "within DataStage" solution.

If you are using a third party scheduling tool, then you need to create some scripts based around the DataStage command line interface, the dsjob command.

I can feel an FAQ coming on.

In version 8.0 the last value can be stored, in a beast called a "state file". This is used in conjunction with a new variation on the Surrogate Key Generator stage.

Or you can Format the Cells in question in Excel.

Are you saying that the zeroes are truncated when you open the CSV file with Excel, or that DataStage is truncating them?

What do you see when you open the CSV file with, say, vi?

Try using string rather than a numeric data type.

You have two choices: Upsert with/without reject link or Load without reject link.

Do you plan to have the Information Repository database server, the WebSphere Application Server and the DataStage server all on the same machine or on separate machines? What network hardware do you plan to use?

Try it?

Four separate specifications, each containing just one value for month?

You HAVE used a Collector, because the last stage in your job design is a Sequential File stage executing in sequential mode. You will be able to see this in the score if you dump the score into the job log. I suggest that the Collector (on the Input tab of the Sequential Stage) is set to Sort/Merge...

No. While operator combination is enabled there is no sensible way to determine which operator is generating the error. Disable operator combination. Describe your job design, so we at least have a clue which index it is that might be too large. Also, if you are using any routines, mention those also.