How can we achieve this?

[mohanraj]

Hi All,

Can anyone please tell me how can we achieve the below result set datastage?

I have a input sequential file with 1000 records. I need 3 output files like this:

1st output file should contain records from 1-30,91-120....

2nd output file should contain records from 31-60,121-150...

3rd output file should contain records from 61-90,151-180....

Please tell me how can we do it in both server and parallel jobs

[ray.wurlod]

Same way. Filter on the row number (@INROWNUM). Force the parallel Transformer stage to execute sequentially - for only 1000 rows it's not worth doing otherwise.

[chulett]

You can also investigate the use of the Mod() function to base your link filter on.