DSXchange

Several.

Parallel job Sort and Aggregator stages are far more robust with large volumes of data. They are NOT based upon their server job counterparts, but have been written specifically to take advantage of the new environment.

Will need to get back to you. Running a QualityStage class this week, don't have the DataStage manuals ready to hand.

A1. File may have been in use. One figure comes from the file header, the per-group figures do not. A2. Total number of data bytes in the file has undergone "arithmetic overflow". This also affects figures based on using this number as a dividend. The number is stored unsigned, but is reported signe...

Derive a stage variable as . You don't have to use the stage variable.

"Not in a runnable state" includes "already running". Check that you don't have the script trying to start the same job twice, or two scripts trying to start the same job at similar times. Otherwise check that the job status is one of "finished", "finished (see log)", "validated", "validated (see lo...

I'm told that the secret of immortality is not to have a life. Perhaps something similar is going on here.

Or different byte order, or different separator, or different column order, or maybe other differences; even the character order can be significant.

The delimiter character actually depends on the requirements of your SMTP mail client.

Unclearly worded question.

Change the Quote Character property to None.

Explore the Modify stage, which has lookup_string_from_int16() function.

Partition by the grouping keys. Make sure that the data are sorted by at least these fields, and in the order specified by the Sort aggregation method if you are using that.

If the header and trailer are differently structured to detail records, they can be captured using the Sequential File stage's reject link. They can be parsed subsequently, if desired, using a Column Import stage.

Officially, no. In one of his blogs Vincent McBurney claims to have done so. But it wasn't easy. There will also, of course, be licensing issues.