DSXchange

SLEEP is not interruptible.

Investigate using task synchronization locks (the LOCK and UNLOCK statements in BASIC). A process will wait on a lock until the owner of that lock (a public numbered semaphore) is released. There is an administrator command for releasing these locks (MASTER LOCKS).

Create a job that sends one row to Oracle, use user-defined SQL.
You may like to identify one key column and add :1 = :1 in the WHERE clause.

Something like that Oracle expected MM/DD/YYYY and you delivered YYYY-MM/DD ?

What is your default date format string? You probably need to override it in your conversion functions.

Do exactly the same things that you did in the first project.

Doesn't Search work for you, gunbala?

Test or post your configuration file.

If you have no export node pool DataStage will use the default node pool. That particular alert message is non fatal.

There is something else wrong - maybe that you lack write permission where you're trying to write the output files.

You don't need to worry about where it is, until you need to change the value of the APT_CONFIG_FILE environment variable. You can view, edit and check configuration files with the Configurations tool (in Manager in version 7.5 and earlier, in Designer in version 8.0 and later).

Post your configuration file so that we can see how (or whether) a default node pool has been defined.

Take IBM's Advanced DataStage (EE) class.

What particular DataStage functions did you attempt to use?

On the left input link of each Join stage.

The idea is to get the outputs of all the Join stages to use the same schema, so that they can be processed by a single downstream stage to effect the combination you desire.

Read the message in the green bar at the top.
Now start a new thread with your specific question.

This may or may not be the same problem as the year-old thread that you hijacked. Because you did not post your configuration file we have no way of knowing that.

This is another example of a silly requirement. You are supposed to changed the way a program works, without changing the program? Do they issue you with a magic wand? You are right that, depending on the load method being used, the already-loaded rows ought to be rejected by the database, and there...

OK, the answer to the original question is that it IS possible. There is a check box in the Job Run Options dialog. In the API there are two functions for enabling/disabling message handlers, named something like DSSetEnableGlobalMsg and DSSetEnableLocalMsg. Still trying to track down some documenta...