how to eliminate the duplicates in sorting
- 4 Answers
- 20871 Views
- Fidelity, I also Faced
- E-Mail Answers
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
Suppose I have five jobs to do. But I want to hold one?
I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
What dd statement is used to supply the name of a dataset?
Define concatenating?
Explain the function of the steplib dd statement?
How can the submitting users racf authority be overridden in a job stream?
How to do automated restart when a job abend?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
How does jcl specify the job to the operating system?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
Explain the job statement in jcl?
Is their any set of rules for dd? Explain.
what is “Cond= even” and “Cond=only”?
