IBM Mainframe JCL and SORT Utility
Questions covering IBM mainframe Job Control Language (JCL), DD statements, and the SORT utility including INREC, OUTREC, OUTFIL, SUM FIELDS, and file operations
Questions
Which statement(s) is/are true for LRECL
- LRECL=0 is valid only for RECFM=F.
- LRECL must not exceed BLKSIZE minus 4 for RECFM=V
- LRECL can not exceed BLKSIZE when RECFM=VS
- LRECL=nnnnnK syntax is valid.
Which parameter indicates when MVS is to free the resource(s) allocated to the DD statement.
- FREE
- RLS
- RLSE
- None of the above.
How does SUM FIELDS = NONE work?
- Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p
- Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it
- Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,
- None of the above
In the i/p file A contains the records in the following sequence: Arun 20 Naveen40 Priya 35 Naveen10 Priya 25 Arun 50 If the following SORT query runs on file A, how would the o/p file B look like: SORT FIELDS = (1,6,CH,A) SUM FILEDS = (7,2,PD)
- Arun 50 Arun 20 Naveen10 Naveen40 Priya 25 Priya 35
- Priya 60 Naveen50 Arun 70
- Arun 70 Naveen50 Priya 60
- Naveen50 Priya 60 Arun 70
In what scenario the sequence field contains the value of 'E' in Sort utility?
- user modified field to be sort ascending
- No specific order specified
- Jumbled order
- None of the above
How does SUM FIELDS = NONE work?
- Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p
- Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it
- Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,
- None of the above
In the i/p file A contains the records in the following sequence: Arun 20 Naveen40 Priya 35 Naveen10 Priya 25 Arun 50 If the following SORT query runs on file A, how would the o/p file B look like: SORT FIELDS = (1,6,CH,A) SUM FILEDS = (7,2,PD)
- Arun 50 Arun 20 Naveen10 Naveen40 Priya 25 Priya 35
- Priya 60 Naveen50 Arun 70
- Arun 70 Naveen50 Priya 60
- Naveen50 Priya 60 Arun 70
How should the SORT statement be used to copy only 10 records with the EMP name 'Anil' to the o/p file, where the Emp name is in the 1st 10 chars of the i/p file?
- SORT FIELDS = (1,10,CH,A),SKIPREC= 10
- SORT FILEDS = (1,10,CH,A),SIZE = 10
- Sort FIELDS = (1,10,CH,A),STOPAFT = 10
- Sort FIELDS = (1,10,CH,A),EQUALS = 10
what are the different types that can be provided in the RECORD Statement?
- F (Fixed), V (Variable), D (ISCII/ASCII Variable)
- F (Fixed), V (Variable)
- No types are specified in the Record Statement
- FI (Fixed), VA (Variable)
How do we resequence a file through the Sort statement where the file record length is 300 bytes and the sequence number is present in the 1st 5 bytes?
- SORT FIELDS=(1,5,ZD,A) OUTREC FIELDS=(1:SEQNUM,5,ZD,6:6,295)
- SORT FIELDS=(1,5,BI,A) OUTREC FIELDS=(1:SEQNUM,5,BI,6:6,295)
- SORT FIELDS=(1,5,ZD,A) OUTREC FIELDS=(1:RESEQ,5,ZD,6:6,300)
- None of the above
An i/p file PRODUCTS contains the records in the following sequence with the fields as SEQ #, PRODUCT NAME, PRODUCT CODE: 0001 LUX 1111 0002 PAMOLIVE 2222 0003 LUX INTERNATIONAL 1111 0004 CINTHOL 3333 Which if the following sort statements would COPY only the LUX products to the o/p file?
- SORT FIELDS = COPY INCLUDE COND = (24,4,CH,EQ,'1111')
- SORT FIELDS = COPY OMIT COND = (24,4,CH,NE,'1111')
- SORT FIELDS = COPY INCLUDE COND = (6,3,CH,EQ,'LUX')
- All of the above
How to multiply the VAT factor .12 with the bought product costs (pos 25-30) in the PRODUCT file and copy to the FINAL file? The file length is 215.
- SORT FIELDS=COPY OUTREC FIELDS=(1:1,24,25,6,ZD,MUL,+0.97,TO=ZD,LENGTH=6,31:31,185)
- SORT FIELDS=COPY OUTREC FIELDS=(1:1,24,25,6,ZD,MUL,+97,DIV,+100,TO=ZD,LENGTH=6,31:31,185)
- SORT FIELDS=COPY OUTREC FIELDS=(1:1,24,25,6,ZD,DIV,+100,MUL,+97,TO=ZD,LENGTH=6,31:31,185)
- All of the above
How to copy the eliminated duplicate records into another file wherein the SORT happens on the 1st 3 characters of the file?
- SORT FIELDS=(1,3,CH,A) SUM FIELDS=NONE OUTFILE FNAME = F2
- SORT FIELDS=(1,3,CH,A) SUM FIELDS=NONE,XSUM
- SORT FIELDS=(1,3,CH,A) SUM FIELDS=NONE COPY = F2
- None of the above
INREC adds, delectes or reformats fields after the records are sorted or merged.
- True
- False
By using _________ statement, data can be sorted in a file between headers and trailers.
- DATASORT
- SUBSET
- both a and b
- None of the above
How to remove the last record from the i/p file?
- SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE LAST = 1
- SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE LAST(1)
- SUBSET FROM(IN1) TO(OUT1) INPUT REMOVE TRAILER
- All of the above
Find the i/p file records as below: Student A - Max = 100 Min = 60 Student B - Max = 60 Min = 50 Student C - Max = 80 Min = 75 How to format the file to the following o/p data? Student A - Maximum = 100 Minimum = 60 Student B - Maximum = 60 Minimum = 50 Student C - Maximum = 80 Minimum = 75
- OPTION COPY INREC FINDREP=(INOUT=(C'Max',C'Maximum',C'Min',C'Minimum')
- OPTION COPY INREC FINDREP=(C'Max',C'Maximum',C'Min',C'Minimum')
- Both a and b
- None of the above
What is the statement to create 2 files from 1 particular i/p file on specific conditions?
- OUTREC
- INREC
- OUTFIL
- None of the above
Which of the following will enhance the efficiency of the jcl?
- INCLUDE COND = (10,3,CH,EQ,C'YES') SORT FIELDS = (1,5,CH,A)
- SORT FIELDS = (1,5,CH,A) INCLUDE COND = (10,3,CH,EQ,C'YES')
- Order doesn't matter
- INCLUDE COND = (10,3,CH,EQ,C'YES') SORT FIELDS = COPY
What is the function of the STEPLIB DD statement?
- Identify a library to be searched for programs named in the EXEC statement
- Identify a library containing executable job steps
- Override the system step library within a job stream
- All of the above