JCL Sort Instream Statements

JCL Sort Instream Statements #answer #jcl #interviewquestions #mainframeguru #mainframetutorial #mainframes #sort #mainframeclasses
JCL Sort Instream Statements - Important to Learn for each individual who are working on mainframe.
1. SORT FIELDS=COPY (It will just copy the data from input to output same as OPTION COPY)
2. SORT FIELDS=(1,5,CH,A) - will sort the data record based on the key which start from 1st position of 5 bytes in ascending order.
3. SUM FIELDS=NONE -To remove the duplicate
4. INREC FIELDS=(1:21,8) - Specifies how records are reformatted before they are sorted, copied, or merged. INREC is useful in case of large input file.
5. OUTREC FIELDS=(1:21,8) -Specifies how records are reformatted after they are sorted, copied, or merged.
6. Will final output be the same? - Yes
7. INCLUDE COND=(1,5,CH,EQ,C’JOHN ’)
8. OMIT COND=(1,5,CH,EQ,C’MANTE ’)
9. Should we use both INCLUDE and OMIT together? – No
10. If we run SORT JCL containing first INCLUDE and second OMIT in same step, what will happen? - Job will execute successfully and ignore the second OMIT functionality.
#mainframeguru #interviewquestions #JCLSortInstreamParameters #instreamparameter, #instream #sortjclinstreamstatement #instreamstatement