DSXchange

What's wrong with a tab with "Glossary" written on it?

Clear, succinct, ...

As a test, try explicitly specifying Hash as the partitioning algorithm on both inputs of the Join stage, using the join key as the partitioning key (and sorting on these).

Sequencers don't use jobs.

Sequences do.

"Come free" means that the other user finishes with it, not that the licence cost suddenly magically vanishes!

The "next version".

Note that the next version will almost certainly make it to GA in 2010; it will spend months in a long, open beta program.

I guess IBM want you all to detect/fix the problems before it goes GA, rather than afterwards.

All possible match patterns are documented in the DataStage BASIC manual (and in UniVerse manuals).

They may even be documented somewhere on DSXchange.

That's probably because Business Glossary User role does not have access to the BG Console, only administrators and authors do, and cosmetic changes are not considered important for these people.

Just my theory.

DSGetJobInfo(hJob, DSJ.JOBINVOCATIONID) should do it.

The same reason that file download rates vary when using Windows - the average is taken over the entire period so any delay will increase the time while not increasing the count as fast, so the average seems to decrease.

What partitioning are you using on the inputs of the Join stage?

Or stage variable to detect whether 'Y' has been encountered, and either stage variables or Key Change column from Sort stage to detect change of key.

If you're updating while data are in transit, use NullToZero() function.

If you need to update in the Oracle table, don't bother using DataStage - execute a simple UPDATE statement against the table.

My guess is locking contention in the target database. Get your DBA to monitor locks.

Check that DSHOME or APT_RESPATH is set. Through one of these environment variables DataStage is able to determine the location of the "resource file" containing the text of messages.

I doubt that you missed much of it, but I've removed the Premium status anyway.