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


Please Help Members By Posting Answers For Below Questions

how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?

1064


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

4564


what are the various stages of job processing?

989


What is the purpose of dd dummy statement?

1164


Must tape dataset definitions include vol=ser specifications?

1328


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

970


What is the use of symbol // in jcl?

1126


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

951


Brief description of inline procedure of jcl.

910


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?

821


what is the purpose of coding notify parameter in job statement?

883


1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat

7408


Explain the function of the steplib dd statement?

834


How to run cobol program using jcl?

882


how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?

1017