sort files with record count !!!

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
balaryan
Member
Posts: 7
Joined: Thu Aug 14, 2014 9:41 am
Location: Chennai

sort files with record count !!!

Post by balaryan » Fri Mar 10, 2017 2:30 am

Hi All,

I am sorting the input file and segregating to four output files based on some conditions along with record count. Then separate the record count from each files for validation purpose.

Right now, I am getting the desired results in two steps.

Step 1: from ONE input file to FOUR output files (trailer record hold record count) using SORT with INCLUDE condition.

Step 2: Using ICETOOL, to get the record count separately into flat files.
SUBSET FROM(IN1) TO(OUT1) KEEP INPUT LAST
SUBSET FROM(IN2) TO(OUT2) KEEP INPUT LAST
SUBSET FROM(IN3) TO(OUT3) KEEP INPUT LAST
SUBSET FROM(IN4) TO(OUT4) KEEP INPUT LAST

I am not sure whether it was doable in the single step using ICETOOL to split the records into four different files along with record count and have separate datasets holding only record count.

Any hint would be appreciated.
B@L@

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