Comparing 2 files using ICETOOL

creativity · New User Joined: 10 Feb 2006 Posts: 3 Location: India

I have two files FILEA and FILEB. FILEA has LRECL = 170 while FILEB has LRECL = 30. Position 1-16 of both files refer to ID number. I need to created three output files in the following way.

OUTFILE1 should contain matching record of FILEA and FILEB,
OUTFILE2 should contain non matching record that appear only in FILEA
OUTFILE3 should contain non matching record that appear only in FILEB

e.g.:

FILEA :

11111111111111111111NAME1.........................
22222222222222222222NAME1.........................
33333333333333333333NAME1.........................
44444444444444444444NAME1.........................
55555555555555555555NAME1.........................

FILEB :

22222222222222222222
55555555555555555555
66666666666666666666
77777777777777777777

The output should be:

OUTFILE1
-----------
22222222222222222222
55555555555555555555

OUTFILE2
-----------
11111111111111111111
33333333333333333333
44444444444444444444

OUTFILE3
-----------
66666666666666666666
77777777777777777777

Please help me out in this. Its Urgent.

expat · Posted: Fri May 18, 2007 4:40 pm

And the topic which was top of the forum before your post deals with this.

http://ibmmainframes.com/viewtopic.php?t=21030

Frank Yaeger · Posted: Sun May 27, 2007 12:15 am

You can use the technique shown in the "Create files with matching and non-matching records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

You'll need to pad the 30 byte records to 170 bytes.