Split the file into multiple

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
pawan.konduru
Member
Posts: 13
Joined: Mon Feb 17, 2014 11:35 am
Location: Hyderabad

Split the file into multiple

Post by pawan.konduru » Fri Feb 22, 2019 9:47 am

Hi,

It will be great help if I get an help in getting the below requirement using SORT.

I have a file with around 27 Million records, with record length of 350 bytes and Rec FM is FB sample is as below

111111111 0011 some other data
111111111 2002 some other data
111111111 2002 some other data
111111111 2012 some other data
111111111 2012 some other data
111111111 9999 some other data
222222222 0011 some other data
222222222 2002 some other data
222222222 9999 some other data
333333333 0011 some other data
333333333 2012 some other data
333333333 9999 some other data

here 1 to 9 bytes is the account number which has multiple segments 0011 is the starting segment and 9999 is the ending segment, I want to split the file to max 5M records each file and The output file cannot be split in between the 0011 and 9999 records need to Keep the full set in same file.
Pawan K

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others