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

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?

Question Posted / sathya

2 Answers
9189 Views
I also Faced
E-Mail Answers

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

what is the difference between JES3 and JES2?

1138

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

1559

What does a disposition of (new,catlg,keep) for a dsn mean?

1159

what are the types of abends that occur on job failure? And explain the possible causes of these

1626

I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

1950

How does jcl specify the job to the operating system?

1251

I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?

10170

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

1388

How to alter the parameters for the existing gdg?

1206

What do you understand by the term notcat 2 – gs?

1246

Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC

4915

What do we mean by 'Virtual storage' for a dataset and for a JOBSTEP ? What is the significance of the following statement for a programmer 'Virtual storage results in program addresses being independent of the addresses that actually exist in a computer' ?

2032

is there any way to execute more than one proc in the same exec statement at the same time..?

2641

When output dataset space is required, what quantity categories are used?

1368

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

1225