RAMESH KRISHNA REDDY mainframe discussion forum - cobol, db2,cics,jcl,file-aid,changeman,... interview questions, quizs
Online Tutorials   | PREV  | TOP  | NEXT



DRONA SERIES
SORT INCLUDE TUTORIAL


CHAPTER - 1


INCLUDE in SORT JCL example



   
 
 
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 
	
SORT INCLUDE EXAMPLE 1 Below example copy the records from input file which contain SURESH at 1st position. 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') /* //* copyright www.mainframegurukul.com .
OUTPUTFILE
SURESH  23447385385933987 PULI 
SURESH  98347385385933987 PULI 
	
    

NEXT CHAPTER TOPIC : SORT INCLUDE COND Example 2


                                   




Home | Donations | Online Tutorials | Books | Entertainment | Contactme | privacy |  sql tutorial | jcl interview questions | JCL Tutorial | JCL Tutorial - chapter1 | JCL Tutorial - chapter2 | JCL Tutorial - chapter3 | JCL Tutorial - chapter4 | JCL Tutorial - chapter5 | JCL Tutorial - chapter6 | JCL Tutorial - chapter7 | JCL Tutorial - chapter8 | JCL Tutorial - chapter9 | JCL Tutorial - chapter10 | JCL Tutorial - chapter11