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


Please Help Members By Posting Answers For Below Questions

Differentiate between addressing mode and run mode.

615


Explain how can the attributes of one sms dataset be copied to another dataset?

705


how to do automated restart when a job abends?

854


Is it possible to left uncode disp?

713


how you can direct the data to spool using SYSOUT option?

927






How can the attributes of one sms dataset be copied to another dataset?

858


Brief description of inline procedure of jcl.

687


Is it possible to left uncode disp? If yes, how?

708


what JCL Procedures?

701


how you will the direct the data to spool using sysout option?

1765


How do you overcome this limitation ?

698


what is SOC4 error?

739


What are the rules employed while naming the steps in a job?

662


What statement marks the beginning of a job step; assigns a name to the step; identifies the program or catalogued or in-stream procedure to be executed in the step?

649


What is the function of dd name parameter with a 2 part structure; audit.report?

700