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,
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)
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)
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
INREC adds, delectes or reformats fields after the records are sorted or merged.
True
False