Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
File Splitting using SYNCSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ribinmathew

New User


Joined: 13 Jan 2009
Posts: 5
Location: Pune

PostPosted: Tue Jan 27, 2009 7:26 pm    Post subject: File Splitting using SYNCSORT
Reply with quote

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
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2285
Location: @my desk

PostPosted: Tue Jan 27, 2009 11:32 pm    Post subject:
Reply with quote

Ribin,

I think this previous topic is similar to yours.

http://ibmmainframes.com/viewtopic.php?t=34987
Back to top
View user's profile Send private message
ribinmathew

New User


Joined: 13 Jan 2009
Posts: 5
Location: Pune

PostPosted: Wed Jan 28, 2009 7:55 pm    Post subject: Reply to: File Splitting using SYNCSORT
Reply with quote

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 ;
Code:
[b]//IN       DD DSN= Your.input.file,DISP=SHR[/b]
and customized to contain 80000 records each in each output file getting created. It ran fine. But no output files were created. Since I'm new to SYNCTOOL utility, i couldn't understand the code and the syntaxes so as to debug. So it would so helpful if you can explain the job.

Thanks in Advance,
Ribin
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2285
Location: @my desk

PostPosted: Wed Jan 28, 2009 9:15 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm
No new posts unable to set RC = 4 when empty file migusd SYNCSORT 1 Tue Nov 21, 2017 1:21 am
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm
This topic is locked: you cannot edit posts or make replies. Need help how to pass the ESP variabl... Venkichaitu JCL & VSAM 12 Thu Nov 02, 2017 3:53 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us