DSXchange

Define those two columns (and no others) as Key on the reference input link. In the Transformer stage drag the two columns from the sequential file into the reference key expression fields. Those two columns will automatically be represented in the WHERE clause on the generated SQL in the ODBC stage...

Given that the computer only uses conditional or unconditional jump when compiled (look at the VLIST), I'd reckon that CASE would be the most efficient. (CASE compiles to exactly the same code as its equivalent nested IF structure, and "break" is automatic.) Ans = 0 Begin Case Case Arg1 <> 0 ; Ans =...

No DataStage stage imposes any limit on the volume of data processed (except where some resource, such as memory or disk space or ulimit) is exhausted . So any restriction will come from your target. This might be a maximum table space size imposed by a DBA, or a maximum file size imposed by an oper...

Of course, if every record was new - that is, not already in the target table - you would also (correctly) observe no records being updated and all records inserted.

An after-job subroutine will not log any events unless you ask it to, by invoking DSLogInfo() or DSLogWarn(). Examine the supplied source code for ExecDOS to see what I mean.

Attempting to cleanup after abort is purely informational, and can be noted and ignored. The actual error has occured in a Link Collector stage, and is a failure to write - presumably to a buffer used by that stage or to a file (Sequential File stage?) connected to its output. This is most likely to...

You can retrieve it and work with it (for example in a downstream Nested Condition activity or Job activity). I don't believe there's any way to view something in a job sequence, but would be happy to be proved wrong. Indirectly, I guess, you could (in 7.5 and later) invoke an Execute Command activi...

The row counts are captured at regular intervals while the stage is running. However, the job can not actually finish until rb_tmu (the Red Brick bulk loader) returns an exit status. So there is a period during which rb_tmu is executing in which DataStage is not processing any more rows, but is mere...

Should I been worried about any performance hit using a Basic Transform instead of the PX native Transform? If you like. It appears (at least in version 7.5.1) that the BASIC Transformer stage does operate in parallel on SMP (share everything) environments, so maybe isn't as much of a bottleneck as...

It's completely unrelated to the thread topic. Please start a new thread. When posting, please include any diagnostic approach you may already have taken, so that you're not wasting our time repeating the same. What is the message telling you? In particular, what do you understand by: XFM010 ,0 oper...

Where did you find it? In a manual? Or trial and error? I just had a quick skirmish through the Parallel Job Developer's Guide and it wasn't obvious there.

DSLogFatal is a BASIC function.

In the DataStage C API there is a function called ds_writelog()
It's prototype is in dsd_gci.h and an example of its use is in dscapi.h, both of which can be found in $DSHOME/gcidir/include on the server.

The whole point of nohup is that, if you close the parent, then myscript should be able to continue executing. Maybe you can create a shell script from which to execute nohup; then closing the console might knock out your shell script, but not its forked nohup process. Otherwise, there's something o...

You can only safely perform updates to records to hashed files only by first reading for update (read cache disabled, lock for updates); then you can amend whatever columns you need to and overwrite the entire record using a second Hashed File stage (write cache disabled). You can perform inserts an...

DSR_MESSAGE has the task of decoding a tokenized message by looking up the local language message text in a Repository table (for example DS_RESENU for English (United States) or DS_RESJPN for Japanese) then substituting values for parameter markers, similar to the way that the C function printf() w...