how to eliminate the duplicates in sorting
Answer Posted / muttaiah
use the Sort utility, In the instream data of the sort card
Specify.
//sysin dd *
sort fields=copy
sum fields=none,xsum
/*
for this you need to have a dd stmt as
//sortxsum dd dsn=datasetname, disp=(createnew, share)
Now, the output file will have the records without
duplicates & the duplicates will be captured in the above
dsn of the sortxsum dd.
Correct me if i'm wrong
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
Differentiate between addressing mode and run mode.
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
How do you submit a job for execution?
Can I send output of job to my remote device careerride123?
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
Explain the function of the dd dcb keyword?
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
in ways data can be passed to a COBOL program from JCL?
Is there any command to check wether the ps file is in sorted order?
What is the use of symbol // in jcl?
What is the purpose of disp parameter?
If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
What is the purpose of the dd keylen parameter?
In job processing, what happens in execution stage?