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
Is automatic restart possible in jcl?
How can an in-stream dataset be terminated?
What is timing concept in mainframe?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
What is the function of dd disp parameter?
Differentiate between the joblib and the steplib statements?
Can I send output of job to my remote device careerride123?
Explain how can values be passed from the job stream to an executable program?
What are the utility programs in jcl?
how you can access an uncataloged dataset in a JCL?
how do you access an uncataloged dataset in a jcl?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
Name a few IBM utility programs, and explain its function.
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
Mention the types of job control statements?