Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

1283


how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?

1339


Explain dd statement in jcl?

1185


how would you create a temporary dataset? And where will you use them?

1499


I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?

2618


How to pass the parameter in parm using linkage section ? (syntax)?

1186


What is multithreading in jcl?

1531


how can you check if a file is empty using jcl?

1490


Explain the function of the dd dcb keyword?

1326


Can we call instream to catalog and catalog to instream?

1188


What is timing concept in mainframe?

2268


What is the purpose of dd dummy statement?

1525


How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?

2325


How to run cobol program using jcl?

1294


Differentiate between the joblib and the steplib statements?

1524