DSXchange

Try to do fewer loads simultaneously. Make sure that pipe files are cleaned up when finished.

Welcome aboard! :D The first message is a warning that there is a difference between the character map set for DataStage NLS and that set by the environment variable NLS_LANG (which may not be set at all). This may affect handling of non-Latin characters, whether in View Data or in processing. The s...

Explain WHY you have this doubt.

Have you run the job? Does it work? Do your Lookup stages have reject capturing or do your jobs have downstream null handling on the looked-up column(s), so you can determine whether the lookups failed?

Two Change Capture stages?

It provides different functionality, so you'd be trying to compare apples with oranges even if you did have a definition of "performance".

And SystemReturnCode is less than zero, indicating that an error has occurred? Please post ALL the text captured in the third argument, not just one field. I suspect - but don't know without seeing the entire output, that the hashed file name does not exist in the VOC file. How, and where, did you c...

If it's a UniVerse table you can do it directly - for example using the DSExecute() subroutine with a first argument of "UV", or using BCI functions using pre-connected handle values @HENV, @HDBC and @HSTMT.

Generating flat files (with a Sequential File stage) of the appropriate format and using a loader for SAP BW will probably be quicker in the DataStage segment than using the BW load stage. However you will need to handle authentication to SAP BW and initiation of the load sequence explicitly - perha...

Welcome aboard! :D

If it's urgent, sign up with your support provider for premium support and learn how much "urgent" costs.

This is an all-volunteer site. People post as and when they can.

Welcome aboard! :D This really is a vague question. While there are many telcos using DataStage, each has different in-house jargon and different requirements. Of course there are some commonalities, such as the handling of CDRs (call data records) and the large volume of these that must be handled ...

While it's true that improvements are needed (that's true of any software product!), I believe the main problem people have with ProfileStage is the clunky way it forces you to follow through the various phases one after another, and the less-than-intuitive steps you need to go backwards to re-run a...

The sixth field of the dynamic array returned by the STATUS statement is the file size in bytes. You might have more luck with FileInfo<2> (have reached end-of-file) or FileInfo<4> (number of bytes available to read). Preferably avoid FileInfo as a variable name, since it is also the name of an inte...

When you restart DataStage always make sure that the DataStage RPC daemon starts.

Check whether you have a default limit set. In Director open the Tools menu and select Options. Then select the Limits tab.

Was this column definition imported from Oracle? If so, it's got to be right, hasn't it?