DSXchange

The name you have given as the database source name in your Oracle OCI stage is not known to Oracle, probably because it is not recorded in the tnsnames.ora file. Get your Oracle DBA to help with configuring this; DataStage is, as far as Oracle is concerned, just another client application.

Try /EDW_Download_Main (with no drive letter, and with UNIX-style forward slashes in the pathname).

But surely you'll end up with the same number of Transformer stages executing with this approach?

This seems to be the date/time created unless permissions have been changed.

Page 6-560 in the manual for version 7.1, page 6-561 in the manual for version 7.5, page 6-561 in the manual for 8.0.

Schema files.

To process a single row a parallel job can never be as efficient as a server job.

Could I suggest using a DataStage job (a server job is most efficient) rather than a UNIX script for extracting the next value from the target table? Using the server job's user status area makes it easier for the job sequence to retrieve the value, which it can do with an unqualified reference to t...

If the data type is Decimal you can not remove the non-significant zeroes, because they don't actually exist. They are an artifact of how DataStage displays decimal numbers to prove that precision and scale are being handled correctly. Internally Decimal data type is stored in a binary format.

What is External1 ?

My guess us that you have typed in what you believe to be the name of a transform function (DS Routine) but which isn't.

The STATUS statement will retrieve date and time created, modified and last accessed, and 25 other pieces of information about a sequential file. Note that I refer specifically to the STATUS statement here, not the Status() function. Check the DataStage BASIC manual for full details. Dates and times...

Yes, any other way. Just start them at the same time. The fact that they have different invocation IDs will make them independent of each other.

Of course you must make sure that this is possible, for example by not having them all write to the same sequential file.

U did not ask the question. U is the name of one of our posters.

This is one of the reasons we ask posters to adhere to a professional standard of written English on DSXchange. DSXchange is not a mobile telephone; SMS may have its place, but DSXchange is not that place.

The OSH code that is generated by compiling a parallel job is stored as part of the job properties. Provided that viewing of the generated OSH has been enabled in the Administrator, then you can view the generated OSH by opening the Generated OSH tab in the job properties dialog. It is OSH (Orchestr...