DSXchange

Once you have named message handler(s) - files with names ending in ".msh" in the MessageHandlers directory - you get an extra option in the dialog for handling a message, and the drop down list of named message handlers becomes available. Choose one from there.

Etiquette Note If no-one has replied it means one of a number of things. >> They don't know. >> They haven't had a chance to log in (it IS a holiday weekend in the US) >> They don't care. Very rare at DSXchange. >> They're still thinking about it. "Push" posts such as yours don't really help. Why d...

That's because Server was specified in the original post. There is no Join stage in server jobs.

Procrastinate until verion 8.0 is available and use its SCD stage.

Why? It all changes completely in the next version.

Check the box that says something like "include system tables". For some strange reason (all complaints to billg@microsoft.com) the ODBC driver for Excel treats worksheets as system tables. They come in with "$" prefixes.

Orchestrate Operators manual is where handle_null() is documented.

1. IsAlpha()
2. IsAlpha(Substring())
3. Index()

... and then what? If the script is invoked from DataStage it must provide ALL responses to the shell script, including the command to end the session. I assume, because the question is posted in a DataStage forum, that such is the intention.

Use some of the other reporting environment variables, to capture the process IDs of the player processes and their memory consumption. Relate these back to your UNIX system monitoring.

Usually because the input data sets are not identically partitioned and sorted on the join keys.

Yet another reason not to rely on rows/sec as a throughput measure!!
Consider the impact if the times differed in the opposite direction - you'd be complaining falsely about poor performance.

Find the name of the routine that is being called and make sure it is properly cataloged in the VOC.

You weren't using two different routines, each of which used Select List #10, by any chance?

chulett wrote:Hmm... I think there is a Dilbert cartoon about trying something over and over, expecting it to eventually work the way to want it to.

This one?

The definition of insanity is doing the same thing over and over and expecting different results.

-- Benjamin Franklin