Wrete a JCL to compare two files and mached records move to
onc file & un mached rows wants to another file?
Answer Posted / kavya
It can be done using icetool.
//STEP001 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=INPUT.FILE1,
// DISP=SHR
// DD DSN=INPUT.FILE2,
// DISP=SHR
//NODUPES DD DSN=OUTPUT.NODUP,
// DISP=SHR
//DUPES DD DSN=OUTPUT.DUP,
// DISP=SHR
//TOOLIN DD *
SELECT FROM(SORTIN) TO(NODUPES) -
ON(x,y,CH) NODUPS
SELECT FROM(SORTIN) TO(DUPES) -
ON(x,y,CH) ALLDUPS
| Is This Answer Correct ? | 91 Yes | 27 No |
Post New Answer View All Answers
what is use of dcb parameter in dd statement?
what is “Cond= even” and “Cond=only”?
what is DD statement is used in JCL?
What is notcat 2 - gs?
What is the purpose of disp parameter?
How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?
Can we call instream to catalog and catalog to instream?
What does a disposition of (MOD,DELETE,DELETE) mean ?
What are the parameter we cannot use in procedure? How many instream we can write in single jcl?
Explain how can an in-stream dataset be terminated?
I need exexution process for JCL programs
How would you understand error(execution phase)?
How can a stopped job be started again?
What are the parameter we cannot use in procedure?
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?