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 want to store 20 digits . how will u do it in cobol ?

1417


What is Cataloged Procedures?

1166


What is the motivation behind coding class parameter in job statement?

1178


Mention the types of job control statements?

1174


How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY

1377


List the various advantages of using jcl language?

1453


I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.

2358


can any one plzzzzzz tell the jcl code for creating ps using idcams

11664


What is the use of symbol // in jcl?

1483


What is timing concept in mainframe?

2203


Explain about ISPF/TSO Commands

1949


What is the function of //cntl statement?

1336


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

2448


How to do automated restart when a job abend?

1387


what is use of disp parameter in dd statement?

1099