Spliting a file into different files using SORT

amalraj_ece · New User Joined: 16 Jul 2006 Posts: 21 Location: delhi

I have a file which contains millions of records of data. I need to split it into 18 files.The number of records is varying each & every month.

dick scherrer · Posted: Thu Mar 15, 2007 1:17 am

Hello,

Please post the "rules" on how you want to split the data? What will cause data to go into file 7 instead of file 16?

Your request is similar to one from a while back that said "I need to write a program". Well, ok, but . . . .

For us to be able to offer suggestions, you need to provide some definition of the requirement.

Why are there 18 files - is that some kind of clue to the downstream processes? Are there 18 locations that need their data split nto an individual file?

Frank Yaeger · Posted: Thu Mar 15, 2007 1:17 am

amal,

I'm guessing you can use the technique discussed in the "Split a file to n output files dynamically" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

If not, then give more details about what you want to do exactly.