Splitting the records based on conditions
Posted: Tue Sep 22, 2009 3:49 am
Hi,
I have 1 million records in an input file.
Using SORT, I want to split the records to 3 files.
- If the column 5 - 10 bytes contains the value '00000', it should go to File 1
- 50% of the remaining records should go to File 2
- 50% of the remaining records should go to File 3
Could you please help me in writing JCL using SORT utility. (I can't ICEMAN here in my company).
Thanks
Vinu
I have 1 million records in an input file.
Using SORT, I want to split the records to 3 files.
- If the column 5 - 10 bytes contains the value '00000', it should go to File 1
- 50% of the remaining records should go to File 2
- 50% of the remaining records should go to File 3
Could you please help me in writing JCL using SORT utility. (I can't ICEMAN here in my company).
Thanks
Vinu