DSXchange

Prove that it was in your Remove Duplicates stage. Post the entire message verbatim.

And? You did not tell us the value you have set for the NLS_LANG environment variable. The message suggests that it is not compatible with the NLS code page setting (ISO8859-1) you have specified for DataStage. NLS_LANG is mainly used by database client software when communicating with database serv...

You chose (on the Options tab) not to export the read-only items.

If you have latterly made some objects read-only, then they won't be exported if this option is selected.

It is NOT a problem. It is a choice you made, whether you were aware of it or not.

What's the basis of the join - the Cartesian product across all tables? If not, what is the basis for selecting corresponding rows from the three tables? For example, you could generate a key from/in each SELECT, and use that as a join key. But what's the right order from each table? More informatio...

You will need to reinstall the production server if NLS is not installed and you want to use NLS. You would do well to read the DataStage NLS manual first since you appear to be unacquainted with it. As Arnd points out, you do not need to uninstall to re-install DataStage server at the same version.

The sequence generated within the database is necessarily sequential. Think about it. Therefore the answer to your question is "no".

Look in the uvconfig file for a tunable called NLSMODE. If it is there, set it to 1 and restart DataStage. If it is not there you will need to re-install the DataStage server, this time with NLS enabled.

Only the same limit that the operating system imposes on the results of regular expressions. There is no limit built into DataStage.

May I suggest that you may be running out of some other kind of resource, trying to process so many files in parallel? Perhaps a different approach is indicated?

ED VOC DSU.ExecSH
I
V
DSU_BP.O/DSU.ExecSH
B
BN
space
space
space
space
DSU_BP.O
Enter
FI

Is the shorter name defined first or second in /etc/hosts?

Is the shorter name defined first or second in /etc/hosts?

Server job CFF stage does not support OCCURS DEPENDING ON. Your only choice, without an EOL character, is to read the file byte by byte. While you can do this in a routine, you probably don't want to. If there are EOL markers, you can at least read each record as a single VarChar, and parse it withi...

You could call a BAPI, but performance would be woeful. A better approach is to build the lookup table locally to your job, in a hashed file. This will offer best performance. Only populate the hashed file with those columns that you actually need in the job, and only extract current rows from R/3 (...

It apears that, in Project B, either someone has written their own ExecSH and compiled it, or that Project B has been around for a very long time (since at least version 5.2). Check whether there is a DEFFUN declaring ExecSH as calling "DSU.ExecSH". If there is, this is at the heart of your problem;...