JCL

SORT JCL to copy when location of matching data is not known If you wish to copy all the records which have a particular string in the file, but its location may vary or is not known then you can use the following sort card  INCLUDE COND=(1,100,SS,EQ,C’ABC’) The above sort card will look for string […]

JCL Interview Questions What are the various operands that can be coded in a JOB statement?          Ans:-Time , Msglevel, Msgclass, Notify, Typrun, Region What is the difference between the Positional and Keyword parameters, provide examples of each? Ans:- Positional parametersas the name suggests these are the parameters that should  be placed

SORT JCL to Copy all records If you wish to copy all records in a file to another file using SORT you can use the Example JCL is provided below. ; ; ; ; //SORTIN   DD DISP=SHR,DSN=USERID.ABC.INPFILE, //SORTOUT  DD DSN=USERID.ABC.OUTFILE, //      SPACE=(TRK,(30,10),RLSE),                    

SORT JCL to put SPACES end of record using INREC or OUTREC The following sort card will take data from 8th pos (3 bytes) and put at 1st pos (3bytes) and take data from 60th pos(8bytes)  and put at 10th position. The data from pos 4th position to 9th position will have spaces (Hex value

Transferring Data from Spool to a Dataset Many a times we need the data sitting in spool to be transferred to a dataset. We might be researching on that data or the client might be looking for that data. To take care of such requests we can make use of any of the two approaches

If you wish to skip certain number of records while sorting you can use the following Where n is the number of records which are to be skipped while sorting Example JCL is provided below. ; ; ; ; //SORTIN   DD DISP=SHR,DSN=USERID.ABC.INPFILE, //SORTOUT  DD DSN=USERID.ABC.OUTFILE, //      SPACE=(TRK,(30,10),RLSE),          

If you wish to stop sorting after say N number of records then you can use the following Where n is the number of records after which sorting is required to be stopped. Example JCL is provided below. ; ; ; ; //SORTIN   DD DISP=SHR,DSN=USERID.ABC.INPFILE, //SORTOUT  DD DSN=USERID.ABC.OUTFILE, //      SPACE=(TRK,(30,10),RLSE),    

SORT JCL to Split data using OUTFIL  The following sort card will sort split the input file into two files. First file will have records which have ‘AB’ at 266th position and second file will have records which have ‘AC’ at 266th position. INCLUDE=(266,2,CH,EQ,C’AB’)      INCLUDE=(266,2,CH,EQ,C’AC’)     Example JCL is provided below ;

SORT JCL to sort in Char format  If you wish to SORT on positions with specific format in desired sequence. You can use the following  The above card will sort the input file from 1st to 15th position with character format in ascending order Example JCL is provided below. ; ; ; ; //SORTIN