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
What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?
What are some jcl statements that are not allowed in procedures?
How can values be passed from the job stream to an executable program?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
How jcl is used for testing batch programs?
What are the utility programs in jcl?
Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE
I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.
how would you create a temporary dataset? And where will you use them?
Which statement is used to identify the private libraries in job?
Brief description of inline procedure of jcl.
what is the purpose of coding notify parameter in job statement?
Explain the function of dd disp parameter?
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 is the function of the steplib dd statement?