SORT INCLUDE examples

 
  






 
  
 

 
 Let us assume input file has following data and structure
  


	
INPUT FILE


	
MOHANK  23423423434534344 KIRAN 
MOHANK  13342345345345345 RAJEEV 
ARAMES  34535345325354324 SURESH 
SURESH  23447385385933987 PULI 
RAMESH  67575789769876785 MADHU 
KRISHN  50830948530859340 OIIED 
KRISHN  30495849572938495 MADHU 
SURESH  98347385385933987 PULI 
	




Aim : Include multiple conditions in sort. (or) comparing 
multiple value with one field value.
 
   
SORT INCLUDE COND in JCL  - 
.
.
//STEP10  EXEC PGM=SORT,REGION=1024K,PARM=parameters              
//SYSOUT    DD SYSOUT=*           Output messages from SORT       
//SORTIN    DD DSN=...,DISP=SHR   Input if SORT request           
//SORTOUT   DD DSN=...            Output for SORT request 
//SORTOFxx  DD DSN=...            OUTFILE output data sets       
//SORTXSUM  DD DSN=...            Output eliminated by the SUM stm
//SORTWKnn  DD UNIT=SYSDA,        Work files if SORT request      
//SYSIN     DD *                  Control statement input data set

    SORT FIELDS=COPY 
     INCLUDE COND=(1,6,CH,EQ,C'SURESH',AND,   -
   (9,3,SS,EQ,C'983,234,133,      - 
                 9A2,8QW,23L')) 


/* 
//* copyright www.mainframegurukul.com
.


In above example, only record will get moved to output file if the field 
starting at position 1 has constant "SURESH" and value at position 9 
matching with any one of the values  983,234,133,9A2,8QW,23L.


Output from above SORT card




	
OUTPUTFILE


	
SURESH  23447385385933987 PULI 
SURESH  98347385385933987 PULI