File Splitting using SYNCSORT

ribinmathew · New User Joined: 13 Jan 2009 Posts: 5 Location: Pune

Hi All,

I have a query in file handling using SYNCSORT. Even though a topic similar to this has already been discussed, posting it again since my requirement differs.

I have a file, ‘PROJ.ABC.DEF’ with say some 500,000 records. (The count of the records vary in each case.)

I need to split this huge file ‘PROJ.ABC.DEF’, into smaller files with each file containing only a maximum of 80000 records.

So is it possible to do so by using ‘SYNCSORT’ so that the first file contains the first 80000 records, the second file containing next 80000 records and so on.

The requirement in my case is that the number of records in the output file which the job is creating, should be constant. (i.e. 80000 records) And the number of records the input file in each case will vary from thousands to lakhs. So can anyone help me in finding out a generic solution.

Thanks in Advance,
Ribin

Arun Raj · Posted: Tue Jan 27, 2009 11:32 pm

Ribin,

I think this previous topic is similar to yours.

ibmmainframes.com/viewtopic.php?t=34987

ribinmathew · New User Joined: 13 Jan 2009 Posts: 5 Location: Pune

Hi,

Many thanks for the pointer. My requirement exactly matches with this post. I tried running this job and got executed fine. But the output files are not getting created. The only change i made is that i customized the job card and also i added the dispostion to the below area where we mention the input file ;

Arun Raj · Posted: Wed Jan 28, 2009 9:15 pm

ribinmathew,

I am not sure about the changes done by you. Can you post the unedited JCL and the DFSMSG messages from your job run using "Code" tags.