DSXchange

Interim status is the job status assuming that the after-job subroutine that calls it returns properly - without generating warnings or errors and with ErrorCode argument set to 0 - that is, the job status that would obtain if there were no after-job subroutine.

Clearly Microsoft knows better than you do exactly what you need!

Yes.

No, but it may be a problem in the Ascential-supplied DataDirect ODBC driver - you need to track down which end of the socket communication got closed, and why.

An ODBC trace, which you can set up in .odbc.ini, would probably be helpful.

You can do this in a DataStage expression using the Minimum() function, but you have to assemble the values into a dynamic array.

None of the messages you posted is a fatal message. You need to find a message with #E at its beginning, not #W. Please post that.

I don't believe it's possible. dscmdexport exports entire projects. dsexport can export a single job, but can not select a category. You could, of course, create a script (BAT file) that combined dsjob and dsexport.

SQLState is a generic ODBC error. Use your favorite search engine to discover more about it. Somewhere, somehow, a socket being used to communicate with DB2 has been closed - you need to do some (external to DataStage) detective work to track that down. Get your DBA and network administrator involve...

What is the value of the TMPDIR environment variable? How much free space is there on /tmp? Is /tmp a local file system or an NFS mount?

Your Repository permissions are incorrect. You are not the owner of or in the group associated with the Repository objects, in this case DSU_BP.O but, I dare say, most of the other objects as well. Alternatively, whoever created this routine has had their umask set too tight (probably 022) which mak...

Welcome aboard. Technically no. However, stages are written to a common API so, if you were to get the OCI stage that is compatible with version 9i (from your support provider) and install Oracle 9i client, then you may be able to get it to work. It is worth testing. Of course the OCI stage for 9i m...

It's available in server jobs.
Use the Surrogate Key Generator stage in parallel jobs.

Search is your friend.

A Sequential File stage will work perfectly well. Each line is read as a single VarChar field (I'm assuming there are line terminators) then parsed in a downstream Transformer stage onto three output links (header, transaction and trailer) based on the first four characters (QTOP, QEND or Qxxx). Par...

There is a DataStage NLS manual. Read that. The CJK characters appear in each of the appropriate Chinese, Japanese and Korean character maps.

Note that server jobs use UV-UTF8 while parallel jobs use ICU (a "true" 16-bit implementation of Unicode).