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...

We are aware of eliminating the duplicate records from
outyput fiel using sort utility. Can we get the duplicate
records in to another file in the Same sort utility?

Answer Posted / sathya

we can get the duplicate records alone in the dataset using
sort utility.

//SORTTA EXEC
PGM=SORT
//SYSIN DD *
SORT FIELDS=(29,9,CH,A)
SUM FIELDS=NONE,XSUM
/*

//SORTIN DD DSN=…,DISP=SHR
//SORTOUT DD DSN=…
//SORTXSUM DD DSN=…
//SYSOUT DD
SYSOUT=*
//
The XSUM control statement is used to create
The output file with the duplicate records alone.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?

1468


How can a jobs execution priority be modified?

1338


Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?

1281


Can an individual step be restricted from using all the jobs allowed cpu time?

1599


What do you understand by the term job time – out and how can you overcome that?

1085


I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?

1260


what operation is performed by job statement?

1172


What do you know about jcl?

1195


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

2513


What are the parameter we cannot use in procedure?

1190


What is use of restart and how to use it?

1358


What is the purpose of the dd keylen parameter?

1280


hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u

2183


What are the parameters that are used in creating a gdg?

1270


Explain the purpose of dd * statement in jcl?

1118