Wednesday, January 19, 2011

SORT syntax

1. SORT 
Syntax for a SORT to include specific records:

//STEP1            EXEC PGM=SORT
//SYSOUT          DD  SYSOUT=*                                   
//SYSPRINT        DD  SYSOUT=*
//SORTIN           DD  DSN=&INFILE,DISP=SHR
//SORTOUT         DD  DSN=&OUTFIL,
//                                              DISP=(NEW,CATLG,DELETE),
//                             SPACE=&SPACE            
//SYSIN              DD  *
    SORT FIELDS=COPY
       INCLUDE COND=(15,1, SS,EQ,C’A,B,C,D’)

//*


In ‘INCLUDE COND’ of SORT, syntax “,SS,” specifies a range for the required field condition separated logically by OR condition i.e. above ‘INCLUDE COND’ syntax is equivalent to:
                        INCLUDE COND=((15,1, CH,EQ,C’A’),OR,
                                                (15,1, CH,EQ,C’B’),OR,
                                                (15,1, CH,EQ,C’C’),OR,
                                                (15,1, CH,EQ,C’D’))

No comments:

Post a Comment