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

can any one plzzzzzz tell the jcl code for creating ps using idcams

10530


What is job control language?

613


i want to store 20 digits . how will u do it in cobol ?

866


I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one

1933


When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

942






I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.

732


WORKING-STORAGE SECTION. 01 GROSS-PAY. 05 BASIC-PAY PIC 9(5). 05 ALLOWENCES PIC 9(3). PROCEDURE DIVISION. MOVE 1000 TO BASIC-PAY. MOVE 250 TO ALLOWENCES. DISPLAY GROSS-PAY. STOP RUN. 77 W-A PIC 9(3)V99 VALUE 23.75 77 W-B PIC ZZ9V99 VLAUE 123.45 after the statement MOVE W-A TO W-B what will be W-B's value? a.123.75 b.b23.75 (where b indicates space) c.023.75 d.invalid move

857


How do you submit a job for execution?

640


How jcl work to handle various input output file operations?

660


how can the same proc be re-used and called by many jobs?

915


What is the use of symbol // in jcl?

933


Explain about LMQUERY�give a dialog information about a data set

907


what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?

780


whats the diff bw the evaluate also and and?

1859


What is the purpose of the dd keylen parameter?

726