how to eliminate the duplicates in sorting
Answer Posted / seema dawlekar
WE CAN ELIMINATE DUPLICATES IN SORTING BY SORT UTILITY
SYNTAX IS
SORT FIELDS=(STARTING POSITING,LENGTH,TYPE,A),EQUALS
SUM FIELDS=NONE
THIS WILL SORT THE FIELDS IN ASCENDING ORDER AND ELIMINATES
ALL THE DUPLICATES, AS WE ARE GIVING 'EQUALS' IT WILL TAKE
THE FIRST RECORD AND ELIMINATES REST OF THE DUPLICATE
RECORDS IN A FILE.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How can values be passed from the job stream to an executable program?
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
Mention the types of job control statements?
what is use of dcb parameter in dd statement?
What is the maximum length of a single line of jcl?
When output dataset space is required, what quantity categories are used?
What is the function of a dd statement?
How jcl work to handle various input output file operations?
How can return codes be tested before execution of a job step?
what happens in conversion stage in job processing?
Explain the purpose of dd * statement in jcl?
Explain how can the disposition of sysout datasets be set for an entire jobstream?
I need exexution process for JCL programs
What is the function of the dd avgrec keyword in sms datasets?
How to submit jcl through a cobol program?