DSXchange

The start point is the first "do not checkpoint run" activity. This setting means that the activity is always run, whether it's a clean start or a restart. Any successfully completed and checkpointed activities are skipped, with events being logged to inform you that they have been skipped. For exam...

Don't re-install a buggy version. Get a new copy.

The most stage variables I have used in a Transformer stage is 220. It was successful.

Looks like it doesn't like IN (in spite of what might be in the manual).

Try rewriting the IN clauses as multiple "=" operations joined by OR.

You can have it right now! Use the job sequence as a prototyping tool, copy the generated job control code into the Job Control tab of a new server job, and adapt to your heart's content!

Please post the routine code.

It may really mean that there is no listener available. Imagine that your Oracle DBA has configured 14 listeners, and 14 are already in use servicing other clients/queries. In this case you will get this message if you attempt to initiate a new query.

It is not a DataStage-generated problem.

You have not provided enough information to enable us to help. How are you declaring the parameters, and how and where in the job design are you referring to them? Precise answers are needed.

The dsidoc.dll library is probably not properly registered.

Possibly two lookups; the first unconditional with a failed lookup rule of Continue, the second conditional upon the first having failed. By this means you could use one job.

You also need a length for string.

Aaaarrggh! Omitted apostrophe, and two occurrences of lower case self-referential personal pronoun!

Apostrophe Man

When you connect you request an instance to be started of the dscs (DataStage common server) service, which runs as dsapi_server. This manages the connection at the server end, including the connection inactivity timeout. If this triggers the dsapi_server process closes down gracefully, closing any ...

Load the reference data into a UV table or an ODBC-accessible table. Use the "multi-row return from reference lookup" capability of the UV or ODBC stage.

Take the IBM classes (DataStage Essentials EE and Advanced DataStage EE). The first gives an overview, the second goes into more detail. The advanced class was written in conjunction with the certification examination, so is useful as preparation for that test.