DSXchange

Hi all,

I am using Parallel Ex.I am facing a problem with @INROWNUM. Actually I have a job where I have to write a single record for any number of records from the source.

the job looks like this:

DataSet->Transformer->Sequential File

For any number of records from DataSet, I have to write a single record's values into that Sequential File.

So, I have used a @INROWNUM and it worked fine, when i have changed the 4 node configuration file, 4 records are written into that file. Now which System Varibale can be used, so that only one record is written into the file? Pls help me out.
Thanks in advance!
Vij

If you search in FAQ section you will find your answer.

@PARTITIONNUM + (@NUMPARTITIONS* @INROWNUM)

You can not expect to write one row in parallel execution. @INROWNUM is calculated on each processing node. Constrain the job to execute in sequential mode - or in a single node node pool - irrespective of the number of nodes in the configuration file.

This POST might be helpful.