DSXchange

Why do you claim that the Aggregator stage is not available?

With sorted input, an approach using stage variables in a Transformer stage is definitely viable.

Probably. DataStage is a 32-bit application, and would be expecting some 32-bit results (bitmasks from SQLColumnInfo() for example).

Most of the UNIX-on-Windows products give access to the full range of frequently-used UNIX commands. Recently I astounded some folks by opening a CMD shell, typing in SH as a command, then displaying man pages! I do err, however, in assuming that everyone has one of these, because they can be had fo...

But the subtopic tells us it's a mainframe job.

The Join stage in mainframe jobs does a pairwise join so, to join five tables you would need to cascade four Join stages.

Probably it's easier to specify the join in the DB2 stage.

That is not documented anywhere public, so you (or someone) would need to discover the answer, either by fiddling with LD_LIBRARY_PATH or by moving/renaming libraries, etc. There are (in the current version) RT_SCnn subdirectories in the project where some of the objects end up, there would be some ...

No. They (usually marketing) typically choose names that convey a message about speed, aggression, whatever. So DB2 v9 was "Viper", DataStage (etc) v8 was "Hawk" (fast and deadly is the message). An earlier version was codenamed "Kobe" - not sure that that was intended to convey!

Welcome aboard. :D

Limit it from getting to the sort. Use a filter on the Sequential File stage that reads the file, using grep or awk to bypass the empty line.

Sometimes I use my brain. Does that count as a third party tool? What if I've just been to three parties, then come to work?

Yes, but that doesn't mean that there are that many. The numbers are not re-used. So this job may have been through many edits. I'd guess that it does have more than a typical number of containers, however.

What's unclear about

either the directory containing the library file
is not on the library search path, or the library was compiled on a system
that is incompatible with this system

?

Make sure that transaction size remains a multiple of array size.

Experiment with increasing array size until no further benefit obtains.

Get your DBA to assist. This is not a DataStage error. It's either in the ODBC driver or in the database server.

You've got something non numeric in your data when a numeric was required (perhaps in an arithmetic expression or function). This may or may not be the date columns that you are reporting about - you will need to do some detective work to determine where the data issue is occurring.

Use stage variables to store the test results, and to create diagnostic information for output. The "rejects" link assembles information from as many stage variables as detect "violations".

There is no limit on the number of stage variables that you are permitted to use.

You may need to set NLSDEFDIRMAP in uvconfig, or to use SET.FILE.MAP to set the map for the directory. Or you may need write permission to the directory to create the hidden file in which the map name is stored.