DSXchange

Is your DataStage client on Windows XP service pack 2? If so, do you have the DataStage xpsp2 patch installed? This sounds like one of the things that patch fixes. You can obtain it through your support provider.

If you can convince "them" to allow it to be an Oracle external table, then you could probably use a Wait For File activity in a job sequence.

The uvconfig file contains configuration parameters for the underlying "UniVerse" engine that is DataStage. The uvregen process creates an image (stored in the .uvconfig file) that is loaded into shared memory when DataStage is started. For example uvconfig contains parameters that define the sizes ...

All before/after job subroutines, irrespective of job type, are server routines. To get individual link row counts use DSJ.INSTROWCOUNT as the fourth argument of DSGetLinkInof().

ULIMIT in uvconfig only comes into play if the UNIX ulimit is lower. Here it isn't. Did you check the job log entry that contains the environment variables, to verify under what user ID the job actually executes?

In the Modify stage, however, counting is zero-based, so you will need to retrieve four characters beginning from position 5.

You use SQLExecDirect() or SQLExecute() (for prepared SQL) functions. There is a lot of structure you have to set up around this, to bind parameters and bind result columns, allocate memory for managing the environment and freeing the same, connecting and disconnection, and handling errors. The suit...

Depends what spA and spB do. You will probably need a job sequence. For example, DELETE FROM T5 requires a job comprising a Transformer stage and a database stage such as ODBC. Use user-defined SQL for the DELETE statement, and a WHERE clause such as WHERE 1 = 1 You can map week number to quarter us...

Sounds like your development project needs to be re-indexed. Search the forum for DS.REINDEX command.

UNIX command split (you are running MKS Toolkit, so can use UNIX commands)

DataStage BASIC function Fold()

Transformer or Filter stage (operating sequentially) constrained on Int(@INROWNUM/5000)

Probably not. Auto will allocate Hash as the partitioning algorithm on the inputs to a Join stage - you can verify this by inspection of the job score. The amount of time taken by the first (or, indeed, any) Join stage is not a factor of the number of output rows - it is a factor of the number of in...

It's not the same user. Look at the environment variables when running a job, to determine the user ID actually running the job. Adjust that user's ulimit. It may also be the case that the ULIMIT configuration parameter in uvconfig comes into play, something else that may be worth checking. Finally ...

Line terminators are converted to field marks (@FM). The Convert() function removes them. When Craig suggested the <1> notation he was attempting to do the same thing, but one can never be totally sure that the result is in the first field (line) of output, which is why I prefer the Convert() approa...

You write a parallel routine. Or you invoke a server routine through a BASIC Transformer stage. Printable characters are defined as in the ASCII range 32 through 126 if NLS is not enabled (however you may have cause to include the accented characters in the code point range 129 through 255 as well) ...

The previous post is totally unrelated to "failure during execution of operator logic". If you have a new topic we expect you to start a new thread, not hijack an existing thread. This makes life easier for future searchers. Once you have searched the forum for your particular error, please create ...