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

What is the purpose of the dd keylen parameter?

725


Which statement is used to identify the private libraries in job?

678


what are the statements that are not valid to be included in an include statement?

776


Explain dd statement in jcl?

644


How can an in-stream dataset be terminated?

849






what sort card you will use to copy the data from one dataset to another dataset?

731


Is it possible to left uncode disp?

713


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

606


What do you know about jcl?

650


when does a dataset go uncataloged?

838


How dummy is used in jcl?

651


Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE

1969


How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?

2173


Explain how can the disposition of sysout datasets be set for an entire jobstream?

636


What are the parameter we cannot use in procedure?

640