sortingdatasetmainframejcldfsort

JCL/DFSORT to split dataset based on header of multi-lined records


I have a dataset with processed information, for 4 distinct departments, and I need to split it into one dataset per department. This is the general record structure:

XXXXXXX = irrelevant string

AAA = 3 letter alpha department ID

Record details are irrelevant, with variable amount of lines

000001 0000000000000000000000000000000000000XXXXXXXAAA171220150000              
000002 <irrelevant record details>
000003 <irrelevant record details>
000004 999999999999999999999999999999999999900000004000000000005700     
000005 0000000000000000000000000000000000000XXXXXXXBBB171220150000              
000006 <irrelevant record details>
000007 <irrelevant record details>
000008 <irrelevant record details>
000009 <irrelevant record details>
000010 <irrelevant record details>
000011 999999999999999999999999999999999999900000004000000000005700     
000012 0000000000000000000000000000000000000XXXXXXXCCC171220150000              
000013 <irrelevant record details>
000018 999999999999999999999999999999999999900000004000000000005700     

How can I accomplish this using DFSORT and JCL?


Solution

  • Here is a sample code for the solution using INREC WHEN=GROUP, for 2 departments:

    //SRT0001    EXEC PGM=SORT
    //SYSOUT     DD SYSOUT=*
    //SORTIN     DD DSN=DATASET.IN,
    //           DISP=SHR
    //AAAOUT     DD DSN=DATASET.OUT.DEPAAA,
    //           DISP=(,CATLG),AVGREC=U,SPACE=(150,(100,10),RLSE)
    //BBBOUT     DD DSN=DATASET.OUT.DEPBBB,
    //           DISP=(,CATLG),AVGREC=U,SPACE=(150,(100,10),RLSE)
    //SYSIN      DD   *
     SORT FIELDS=COPY
       INREC IFTHEN=(WHEN=GROUP,
         BEGIN=(1,4,CH,EQ,C'0000'),
         END=(1,4,CH,EQ,C'9999'),
         PUSH=(151:45,3))
       OUTFIL FNAMES=AAAOUT,
         INCLUDE=(151,3,CH,EQ,C'AAA'),BUILD=(1,150)
       OUTFIL FNAMES=BBBOUT,
         INCLUDE=(151,3,CH,EQ,C'BBB'),BUILD=(1,150)
    /*