DSXchange

Welcome aboard. :D

This is precisely the function of the Merge stage in server jobs. It can perform inner joins as well as outer joins.

If you have genuine UniVerse (not DataStage) you can set up ODBC access to it. I have also used an External Source stage to get data out of UniVerse into a parallel job. Construct a query that does not column wrap (perhaps using FMT to override the default field widths and setting the device width s...

Great answer from Daniel - not much I can add to that.

If your other post was anything to go by, most of the nodes are purely for interacting with DB2. Is this the case? Where is the slowness?

Basically it's the number of node definitions. Your configuration file has six, so the documentation at its head is incorrect. stage01_node1 stage02_node1 bdwux201 bdwux202 bdwux203 bdwux204 The first two are on machines etlux201 and etlux202 respectively, the remaining four are on machines bdwux201...

You're on Windows. Windows does not have a cat command (though there is on in MKS Toolkit, which you might have installed). DataStage on Windows does not record the installation directory in /.dshome - rather it uses a Registry entry.

Try

At the operating system prompt execute the command
This will not only decode the code, but may also recommend remedial action that you can take.

Whatever replacement date value you give must correspond exactly to the date picture currectly specified for the job, unless you override that with a formatting option (for example in the handle_null() specification in a Modify stage).

Major changes in the next release ("Hawk"). There will no longer be any fixed categories. You can store any mix of components in any folder.

This is a known bug in 7.1 and later. Alas I don't have the ecase number, nor can I recall the particular circumstances under which it occurs.

You can use all "UniVerse" commands on both UNIX and Windows.

Use a 'select items from list' StartLoop activity in a job sequence. The list can be generated by any command/regular expression.

Teradata EE is likely to give you the best performance (throughput) of all the Teradata stage types. Are you taking proper advantage of parallelism?

sqlldr not found indicates that your ORACLE_HOME (or ORACLE_BIN, if you have it) or PATH environment variable is not set in your new environment so as to be able to find the sqlldr executable, or that you lack execute permission to one or more of the directories in its pathname.

You may be the Administrator, but are you the DBA?
to find out.