DSXchange

1. Maybe. It depends where the files are and how many of them there are. 2. There is no "read multiple nodes" - there is "multiple readers per node". In this case, if you specify N readers per node for one sequential file, only one node gets used, and each reader on that node reads 1/N of the lines ...

1. No, setting stable sort alone will not cause the data to be sorted. However, this option does not become available unless you choose to sort the data (and specify sort key(s)) - it is THIS that gets the data sorted (whether a stable sort or not). 2. See answer to 1. 3. You specify this property f...

$ENV as the default value means that DataStage is instructed to obtain these values from the parent process's shell. Have these environment variables been set before DataStage is started? Otherwise prefer $PROJDEF for the default value, so that values set up in the Administrator client may be picked...

Yes, but if the data type is Char, then pad characters will be written back. Hence my question about data type.

1. False.
2. False.
3. No.

Have you run the script that switches to emulation mode (I think it is called)?

Not correct. Stable sort means preserve the ARRIVAL ORDER OF ROWS - nothing to do with keys at all.

Hi ArndW, If i will call the Unix command from command satge how can I capture the command stage result into User variable activity stage. Thanks, N.Raju Using the Execute Command activity's $CommandOutput activity variable in the definition of the user variable. You may need to remove field mark (...

The question was specifically "in a parallel job".

What is the data type?

Yuck.

Certainly. They are called job parameters, and are read-only within the job.

Otherwise, add columns to the links that are flowing through the job and you can change these as often as you need.

They are not the same. Stable sort can apply even when you are not using either of the "Don't sort" options. Stable sort preserves existing order of rows when the sort keys match. This needs more memory than not doing a stable sort.

Nripendra Chand wrote:this job was running fine previously and now only it is aborting.

What has changed? "Nothing" is not the correct answer, though the thing that has changed may not be a DataStage thing. Track it down.