DSXchange

Look in the job properties, (Parallel) Execution tab.

Possibly also due to incorrect partitioning.

Please post the generated OSH from this job, or at least the record schemas from them.

It this question any different from the one in this post?

Yes. You use substring or Field() function to extract the date portion as a string from your input value.

Look in the Advanced tab of every stage in your job design. It will probably be in one (or more) of them.

Downloadable for free from IBM website

Read the Help when you are in this screen. This property governs how often you want to send COMMIT commands to the database server. A value of 0 means not to send a COMMIT until all rows have been sent - this is the safest for recovery, but can mean that the database server may need to handle large ...

You need to be able to "see" the IADB from the DataStage server machine (the UNIX machine). All IA tasks actually run as DataStage jobs in the ANALYZERPROJECT project. To configure ODBC from UNIX you need to edit the $ODBCINI file (usually .odbc.ini in the DataStage Engine directory) and the uvodbc....

An Execute Command activity in a job sequence will execute an operating system command directly, and make its output and exit status available as activity variables that you can use to control Triggers or access in downstream activities. Beware that the command output is converted to a single string...

If you are constructing queries in a Hashed File stage, the Selection has to be expressed using the RetrieVe query language. There is also a UniVerse manual for RetrieVe.

Did you force re-compile the job? A regular compile does not re-compile an unchanged Transformer stage, so this may have hung on to its record schemas.

Look at the job score. Inserted tsort operators exist because the Join stage requires sorted inputs.

... or go back to Red Brick. :D No other database (as far as I am aware) supports automatic maintenance of aggregates from bulk loader. For IDS you can use any of the stage types you mentioned - the Informix CLI stage is likely to be the most efficient. However you will need to design all the logic ...

You can not. It will not install.