Tag: mainframe

Questions Related to mainframe

In what scenario the sequence field contains the value of 'E' in Sort utility?
technology mainframe

  1. user modified field to be sort ascending

  2. No specific order specified

  3. Jumbled order

  4. None of the above

Show answer
Correct Option: A

How does SUM FIELDS = NONE work?
technology mainframe

  1. Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p

  2. Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it

  3. Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,

  4. None of the above

Show answer
Correct Option: B

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)
technology mainframe

  1. Arun 50 Arun 20 Naveen10 Naveen40 Priya 25 Priya 35

  2. Priya 60 Naveen50 Arun 70

  3. Arun 70 Naveen50 Priya 60

  4. Naveen50 Priya 60 Arun 70

Show answer
Correct Option: C

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?
technology mainframe

  1. SORT FIELDS = (1,10,CH,A),SKIPREC= 10

  2. SORT FILEDS = (1,10,CH,A),SIZE = 10

  3. Sort FIELDS = (1,10,CH,A),STOPAFT = 10

  4. Sort FIELDS = (1,10,CH,A),EQUALS = 10

Show answer
Correct Option: C

what are the different types that can be provided in the RECORD Statement?
technology mainframe

  1. F (Fixed), V (Variable), D (ISCII/ASCII Variable)

  2. F (Fixed), V (Variable)

  3. No types are specified in the Record Statement

  4. FI (Fixed), VA (Variable)

Show answer
Correct Option: A

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?
technology mainframe

  1. SORT FIELDS=(1,5,ZD,A) OUTREC FIELDS=(1:SEQNUM,5,ZD,6:6,295)

  2. SORT FIELDS=(1,5,BI,A) OUTREC FIELDS=(1:SEQNUM,5,BI,6:6,295)

  3. SORT FIELDS=(1,5,ZD,A) OUTREC FIELDS=(1:RESEQ,5,ZD,6:6,300)

  4. None of the above

Show answer
Correct Option: A

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?

technology mainframe

  1. SORT FIELDS = COPY INCLUDE COND = (24,4,CH,EQ,'1111')

  2. SORT FIELDS = COPY OMIT COND = (24,4,CH,NE,'1111')

  3. SORT FIELDS = COPY INCLUDE COND = (6,3,CH,EQ,'LUX')

  4. All of the above

Show answer
Correct Option: D

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.
technology mainframe

  1. SORT FIELDS=COPY OUTREC FIELDS=(1:1,24,25,6,ZD,MUL,+0.97,TO=ZD,LENGTH=6,31:31,185)

  2. SORT FIELDS=COPY OUTREC FIELDS=(1:1,24,25,6,ZD,MUL,+97,DIV,+100,TO=ZD,LENGTH=6,31:31,185)

  3. SORT FIELDS=COPY OUTREC FIELDS=(1:1,24,25,6,ZD,DIV,+100,MUL,+97,TO=ZD,LENGTH=6,31:31,185)

  4. All of the above

Show answer
Correct Option: B,C

How to copy the eliminated duplicate records into another file wherein the SORT happens on the 1st 3 characters of the file?
technology mainframe

  1. SORT FIELDS=(1,3,CH,A) SUM FIELDS=NONE OUTFILE FNAME = F2

  2. SORT FIELDS=(1,3,CH,A) SUM FIELDS=NONE,XSUM

  3. SORT FIELDS=(1,3,CH,A) SUM FIELDS=NONE COPY = F2

  4. None of the above

Show answer
Correct Option: B

INREC adds, delectes or reformats fields after the records are sorted or merged.
technology mainframe

  1. True

  2. False

Show answer
Correct Option: B