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
 
Understanding Sort Control Cards

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Mar 12, 2013 7:04 am    Post subject: Understanding Sort Control Cards
Reply with quote

For this topic the TS has taken a wander, so I'm putting what I prepared here:

Code:
 OPTION COPY                                                           
 INREC IFOUTLEN=80,IFTHEN=(WHEN=INIT,OVERLAY= (26:SEQNUM,1,ZD)),
       IFTHEN=(WHEN=GROUP,BEGIN=(26,1,BI,EQ,B'.......1'),
              RECORDS=2,PUSH=(38:1,2,32:SEQ=1)),
       IFTHEN=(WHEN=GROUP,BEGIN=(26,1,BI,EQ,B'.......0'),
              RECORDS=2,PUSH=(45:1,2)),
       IFTHEN=(WHEN=(45,2,CH,EQ,C' '),OVERLAY=(20:C'W',4:C'00')),
       IFTHEN=(WHEN=(32,1,CH,EQ,C'2'),
               OVERLAY=(20:C'X',4:1,2,ZD,
                       SUB,38,2,ZD,TO=ZD,LENGTH=2)),
       IFTHEN=(WHEN=NONE,
              OVERLAY=(20:C'Y',4:1,2,ZD,
                       SUB,45,2,ZD,TO=ZD,LENGTH=2))                         
 OUTFIL REMOVECC,
        HEADER1=(20:C'TYPE',
                 26:C'SEQN',
                 32:C'OSEQ',
                 38:C'LNUM',
                 45:C'RNUM')
//SORTIN   DD *
10
15
17
25
30
35
40
45
50
55
99


Which produces this output (or should, it is untested reformatting of the results of the symbol substitution carried out by DFSORT and could easily contain some typos):

Code:
                   TYPE  SEQN  OSEQ  LNUM   RNUM
10 00              W     1     1     10         
15 05              X     2     2     10     15 
17 02              Y     3     1     17     15 
25 08              X     4     2     17     25 
30 05              Y     5     1     30     25 
35 05              X     6     2     30     35 
40 05              Y     7     1     40     35 
45 05              X     8     2     40     45 
50 05              Y     9     1     50     45 
55 05              X     0     2     50     55 
99 44              Y     1     1     99     55 


Now, I didn't write the code like that, I wrote it like this:

Code:
//STEP0100 EXEC PGM=SORT
//SYMNAMES DD *
* INPUT RECORD
    INREC-NUMBER,1,2,ZD
SKIP,1
* NEW DATA FOR OUTPUT RECORD
    OUTREC-DIFF-TO-PREV-REC,*,2,ZD
* OVERLAYED/PUSHED DATA
    TPYE-FLAG,20,1,CH
SKIP,5
    EXTEND-SEQNUM,*,1,ZD
    EXTEND-SEQNUM-BI,=,=,BI
SKIP,5
    EXTEND-ODD-SEQ,*,1,ZD
    EXTEND-ODD-SEQ-CH,=,=,CH
SKIP,5
    EXTEND-LEFT-NUMBER,*,2,ZD
SKIP,5
    EXTEND-RIGHT-NUMBER,*,2,ZD
    EXTEND-RIGHT-NUMBER-CH,=,=,CH
* CONSTANTS
*  TESTS
    AN-ODD-NUMBER,B'.......1'
    AN-EVEN-NUMBER,B'.......0'
    NUMBER-AT-LEFT,C'2'
    FIRST-RECORD-ON-FILE,C' '
*  VALUES
    ZERO-FIRST-CALC,C'00'
*  FLAGS
    FIRST-TO-BE-ZERO,C'W'
    VALUE-FROM-LEFT,C'X'
    VALUE-FROM-RIGHT,C'Y'
//SYSOUT   DD SYSOUT=*
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *
  OPTION COPY
                                                                     
  INREC IFOUTLEN=80,
                                                                     
        IFTHEN=(WHEN=INIT,
                 OVERLAY=(EXTEND-SEQNUM:SEQNUM,1,ZD)),
                                                                     
        IFTHEN=(WHEN=GROUP,
                      BEGIN=(EXTEND-SEQNUM-BI,EQ,AN-ODD-NUMBER),
                      RECORDS=2,
                      PUSH=(EXTEND-LEFT-NUMBER:INREC-NUMBER,
                            EXTEND-ODD-SEQ:SEQ=1)),
                                                                     
        IFTHEN=(WHEN=GROUP,
                      BEGIN=(EXTEND-SEQNUM-BI,EQ,AN-EVEN-NUMBER),
                      RECORDS=2,
                      PUSH=(EXTEND-RIGHT-NUMBER:INREC-NUMBER)),
                                                                     
        IFTHEN=(WHEN=(EXTEND-RIGHT-NUMBER-CH,EQ,FIRST-RECORD-ON-FILE),
                 OVERLAY=(TPYE-FLAG:FIRST-TO-BE-ZERO,
                          OUTREC-DIFF-TO-PREV-REC:ZERO-FIRST-CALC)),
                                                                     
        IFTHEN=(WHEN=(EXTEND-ODD-SEQ-CH,EQ,NUMBER-AT-LEFT),
                 OVERLAY=(TPYE-FLAG:VALUE-FROM-LEFT,
                          OUTREC-DIFF-TO-PREV-REC:INREC-NUMBER,
                         SUB,
                          EXTEND-LEFT-NUMBER,
                           TO=ZD,LENGTH=2)),
                                                                     
        IFTHEN=(WHEN=NONE,
                 OVERLAY=(TPYE-FLAG:VALUE-FROM-RIGHT,
                          OUTREC-DIFF-TO-PREV-REC:INREC-NUMBER,
                         SUB,
                          EXTEND-RIGHT-NUMBER,
                           TO=ZD,LENGTH=2))
                                                               
  OUTFIL REMOVECC,
         HEADER1=(TPYE-FLAG:C'TYPE',
                  EXTEND-SEQNUM:C'SEQN',
                  EXTEND-ODD-SEQ:C'OSEQ',
                  EXTEND-LEFT-NUMBER:C'LNUM',
                  EXTEND-RIGHT-NUMBER:C'RNUM')
                                                               
                                                               
//SORTIN   DD *
10
15
17
25
30
35
40
45
50
55
99


The output is shown in that way to aid the understanding of the solution.

Using the symbols/SYMNAMES it was very easy to produce a report on OUTFIL with column headings.

The spacing would not be used for the end solution, but very simply all the SKIP,5s would be removed, the FLAG and references to it would disappear (the purpose of the flag is to indicate which IFTHEN did what) and the OUTFIL would be removed. Everything still works, nothing to change.

The requirement can also be satisfied by using JOINKEYS along the lines of either of these examples:

http://www.ibmmainframes.com/viewtopic.php?p=291631#291631
http://www.ibmmainframes.com/viewtopic.php?p=300686#300686

They provide a means to have the "current" and "previous" records together on the REFORMAT record.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to control the elapsed time for a... Philippe JCL & VSAM 12 Thu Aug 09, 2018 5:54 pm
No new posts How to remove spaces between variable... Selvarajars DFSORT/ICETOOL 7 Fri Jul 27, 2018 3:58 pm
No new posts finding anydata between positions of ... ram_vizag SYNCSORT 13 Tue Jul 17, 2018 9:14 pm
No new posts In which program the FILE CONTROL wil... Poha Eater COBOL Programming 2 Thu Jun 28, 2018 9:02 pm
No new posts To remove spaces from a VB file using... Selvarajars DFSORT/ICETOOL 5 Thu Jun 21, 2018 6:57 pm

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