DSXchange

Don't need Informatica in the equation for that. Hence the need/demand for a Server to Parallel Transition Lab to help folks to unlearn some server job "square pegs".

Yeah. Hmm. "External tables"?

Is there a before-job or before-stage subroutine that is creating a header? Are you overwriting or appending to the file?

Capture and inspect the score - the script that is actually executed, rather than the generated osh.

Your shared library search list (LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH) is not set up correctly. It does not include the parent directories of the libraries indicated in the error messages. You need to ensure that it does, where the list is configured in the dsenv script.

IS there a Folder stage in parallel jobs? If not, follow the suggestion of using an External Source stage.

The DataStage licensing check will report that you have 32. If you have licensed for fewer you will receive warnings.

Nice try but, if so, what's a SAP dataset?

There's nothing to exemplify. Can multiple clients use the database? Yes. DataStage job is just another client application, as far as the database is concerned.

Does the answer in this post (a duplicate from you) help?

A further search will reveal the column names in RT_LOGnnn tables. You can use a Hashed File stage or a UV stage to extract records from the log tables in a regular DataStage job and dump them to a text file by that means. There is also a Print option in the Project menu in Director that allows you ...

Timeout waiting for a job to start may be (usually is) a symptom that something in the execution environment is overloaded - either processing capacity or network capacity are the usual suspects.

Seems like the DB2 client software is not correctly installed or configured on the DataStage server machine, or on one of the processing nodes. This might be something as simple as getting the shared library search list correct in the dsenv script.

You can not pass them the the parameters of the job sequence itself (these are locked in when the job sequence starts), but you can use user variables or activity variables to retrieve the results.

If you read the file without "first line is column headings" checked, then the first row will be regarded as data. If you then write a file with column headings checked, the header is written, then the first row of data that you read (a header again) is also written, then the remaining data rows are...

Try specifying a space character or the equivalent decimal ASCII code (032) as the delimiter character on the Format tab. Otherwise please post sample data and some information about what is supposed to be in each column (field). Enclose data in Code tags so we can get a feel for the record layout.