DSXchange

As well as being the accepted abbreviation for cosine, "cos" is also a kind of lettuce. There is a COS (cosine) function available in DataStage, but it is a numeric function and therefore probably would not be affected by NLS settings.

DSRTrace has detected that at least one trace mode is enabled.

[OK]

Include tests (triggers) in the job sequence to control precisely what you want to happen. An hour or so spent thinking about what you want to happen and designing the same on paper would be an hour productively spent.

Sadly incomplete, and wrong in places. For example RT_CONFIGnnn does not contain executables (and in no sense could be considered to), the DSD.RUN program is not an interface, DSD.GenRuntime.B is not a compiler, status is updated in RT_STATUSnnn not just for jobs, but also for active stages and "res...

Change the run mode to "reset if required, then run".

How do you propose to get required information out of the control table? With this knowledge we will be able to advise more accurately, without guessing how you are trying to do things.

What are you trying to achieve by invoking a sparsely documented command from a routine? If you're in a routine System(32) may be easier than hacking around with environment variables.

Only maybe. This technique is more reliable for server jobs than parallel jobs.

I don't know. It's your question.

CRC32() uses an algorithm to generate a 32-bit integer, repeatable for any given argument. Therefore it has approximately a one chance in 2^32 (one in 4,294,967,296) of generating a false positive. If that's within your comfort zone, go for it. Make sure there are no NULL values in the argument.

Close enough if you believe that the date you get from Oracle should match the date picture. Where does the ".0" spring from anyway?

It can connect to queues on other servers. The local queue manager uses MQ intercommunication to communicate with the remote queue manager(s).

Pre-process the file in an Execute Command activity executing the command wc -l filename

Read the last line of the file using tail -1 filename

Compare using test command.

Decide, on this basis, whether or not to run the job or to report a row count reconciliation error.