DSXchange

Check the (DB2) help on COALESCE function.

Perhaps it only takes column names as its arguments?

No.

But the answer is no whether it's a server job or a parallel job.

You're wrong (you did invite it). DataStage projects can be created in any directory except the root directory. DataStage engine can be installed in any directory except the root directory. It's only the default that is /opt/IBM/InformationServer.

Your target column is VarChar(4).

Check again.

Since you can not cross-mount file systems, there's no solution. If you could, you probably would still have somehow to construct a descriptor file on machine2 that properly referred to the segment files in the Data Set itself. Even I would not be confident that that could be done. Perhaps an altern...

Dump the score (set APT_DUMP_SCORE to True). This will tell you which processes are allocated on which nodes. Nodes are numbered (from zero) in the order specified in the configuration file.

There is (should be) NO WAY that you can put a null into a Not Null column.

It really does depend what you're doing with the ETL. An obvious enhancement is ETLstats ( downloadable from Kim Duke's website), to gather all kinds of process metadata. In most applications you can enrich the data with calculated columns based on re-usable components, such as functions

Run time source code. There can be more than two files - there will be more than two files if the job includes a Transformer stage.

If COLUMN1 or COLUMN2 is null in any particular row, then the WHERE clause for that particular row cannot be realized.

Initialize a stage variable to DSJobStartTimestamp and use this stage variable rather than re-evaluate the macro twice for every row processed.

For Char data type the Null Field Value must have the correct number of characters for the field. This has been explained about a bazillion times here.

Welcome aboard.

Is there anything in the record, such as a run ID or updated date, that you can use to select the record after it's been inserted (and the identity key generated)?

Welcome aboard.

What are you doing in the SELECT? Any grouping or join? What are you doing in the Transformer stage?

If the table has a scale definition of 3, yes.