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

When space is allocated for an output dataset, what units can be used?

740


What is the use of symbol // in jcl?

918


define cond parameter in jcl?

771


I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?

705


How do you submit a job for execution?

637






Can we call instream to catalog and catalog to instream?

681


What is the difference between the positional and keyword parameters? Give examples.

702


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

604


what is DSN in JCL and what are the parameters to declare the DSN?

714


What is the function of //jcllib statement?

798


Is acct parameter mandatory?

758


Define concatenating?

663


List the different components of jcl statement?

687


Explain the function of job statement in jcl?

644


in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?

2050