File comparison using ICETOOL

nnaveenreddy · New User Joined: 19 Jul 2005 Posts: 7

I have 2 files as in put

File1
1Record1X
2Record2X
3Record3X
4Record4X
5Record5X
6Record6X

File2
7Record7X
5Record5X
4Recor44X
3Record3X
2Recor22X
1Record1X

when I used the following JCL

//S010 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=MIS.INPUT.FILE.FIRST,DISP=SHR
// DD DSN=MIS.INPUT.FILE.SECOND,DISP=SHR
//OUT DD DSN=MIS.OUTPUT.FILE.NO.DUP2,
// DISP=(,KEEP,DELETE),
// RECFM=FB,LRECL=80,
// SPACE=(80,(10,10),RLSE)
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,9,CH) NODUPS
/*
//

I am getting the below output

2RECORD2X
2RECOR22X
4RECORD4X
4RECOR44X
6RECORD6X
7RECORD7X

But my output should come as

7Record7X
6Record6X
2Recor22X
4Recor44X

Basically I need two compare the first file with second file and if any changes in second file then I need to write the second file changes and not first file changes.

dick scherrer · Posted: Wed Oct 17, 2007 3:17 am

Hello,

Does your system run DFSORT or is some other sort product used? You can tell from the sysout information created when you run your job.

nnaveenreddy · New User Joined: 19 Jul 2005 Posts: 7

Yeap..my system run on DFSORT and as well as sort utilities

Frank Yaeger · Posted: Wed Oct 17, 2007 5:01 am

nnaveenreddy,

DFSORT/ICETOOL did what you told it to. It found all of the unique records from your input concatenation of file1 and file2.