DSXchange

What's really needed is a change in mindset. In server jobs a Fatal error always causes the job to abort. In parallel jobs this is not necessarily the case - the controlling process (section leader or conductor) makes a decision about whether the other players, other nodes, can continue to execute.

I suspect option "DWA" or "DWB" would suit your purpose better. Just guessing.

The NextSurrogateKey() function works like a sequence in a database - it delivers the next value irrespective of who's asking for it. Which node, in this case. Surrogate keys only have to be unique - their actual value has no meaning.

I'm reminded of the old statisticians' joke: "what's the birth rate around here?" "One each." There is a pretty neat "UniVerse" solution to this, but it does require some advanced skills to get it right. Basically you need to silently intercept the LOGIN and LOGOUT in e...

You can import the table definition for the sequential file, marking it as fixed width and providing the column widths (on the Format tab) and column names (on the Define tab).

The branded_odbc directory is not a subdirectory of DSEngine. Go up a level.

Certainly. Review the code for OpenSequentialFile routine (published on DSXchange) to learn about overwrite/append sequential files using DataStage BASIC.

DSGetLinkMetadata() is documented on page 96 of the DataStage Programmer's Guide. It returns a dynamic array. You don't actually have to count anything. Here's how I'd approach it. * assuming JOBCONTROL.H is included Result = DSGetLinkMetadata(hJob, StageName, LinkName) ColumNames = Result<1> KeyCol...

Welcome aboard.

To generate null, use SetNull() function. Add your own logic to determine whether your condition is met.

Why do you have this need?

No.

Even more efficient (not evaluating the Space() function every row is to evaluate it when initializing a stage variable, or simply use a literal.

Try purging the log of all entries.

Check the version of the Oracle client software installed on your DataStage server, and that the Oracle environment variables are correctly set.