DSXchange

The original question was marked "parallel job" and I answered thus.

In both parallel and server jobs forcing an abort will roll back any uncommitted transactions.

Committed transactions have, well, been committed.

Or you could make an Otherwise/Log output link (from the Transformer stage) which will serve the same function but which does allow you to specify the record schema on it.

Need to think about that for a bit. Meanwhile why not simply perform the join in DB2, since that seems to work?

Marginal. With a Data Set the index (hash table) has to be built; with a Lookup File Set the index already exists and only needs to be moved into memory. For large reference sets the difference is negligible; for smaller reference sets it will be noticeable. The ability to view data is purely cosmet...

DataStage does not really have a lookahead capability, but you can "remember" the values from the prior row using stage variables.

This is done row by row.

No, I mean the record schema. You can find this in the table definition (parallel view) or in the generated OSH.

And the record schema?

Be warned that there are several errors in this manual. Correct information can be found in the Orchestrate Operators manual.

Running DataStage server on a supported operating system would be favourite.

"Null archive" suggests that the thing you are trying to view does not exist.

Among other things there appears to be a problem allocating communication resources. Are you hitting operating system limits such as the number of inodes available? As you are probably aware, each log event with (...) in its subject contains more information which may be useful. You can see the addi...

You need a controlling job sequence (that does not abort) to run your Master Sequence.

Note that a Sequencer is something you have within a job sequence - it is not separately executable.

Yes, but why not use an inner join? You can readily enough isolate those rows (perhaps with head and tail stages).

Ur was a city in ancient Babylonia - the second person possessive pronoun is spelled "your".

Are the two fields identically trimmed?

This is an OLE Automation error in Windows. The connection to the OLE server that exposes the objects in question has been lost.

Is this reliably reproducible? If so please report it to your support provider as a bug.