Comparing two files

cima · New User Joined: 22 Mar 2006 Posts: 8

Hi,

I would like to compare 2 files, where I want to know which are present on both files or if only on one file, then it should indicate like in the output.

Example:

1st File:
ID01zzzzBBBBzzzzzzzzzzzzzzzzzzzzzzzzzzzz
ID02xxxxBBBBxxxxxxxxxxxxxxxxxxxxxxxxxxxx

2nd File
ID01xxxxAAAAxxxxxxxxxxxxxxxxxxxxxxxxxxxx
ID01yyyyBBBByyyyyyyyyyyyyyyyyyyyyyyyyyyy
ID03xxxxBBBBxxxxxxxxxxxxxxxxxxxxxxxxxxxx

OUTPUT:
MATCH ID01BBBB
FILE1 ID01AAAA
FILE1 ID02BBBB
FILE2 ID03BBBB

Hopefully its detailed enough..

Thanks,
cima

expat · Posted: Fri Oct 29, 2010 1:31 pm

Option 3.14 from your ISPF primary menu

Arun Raj · Posted: Fri Oct 29, 2010 1:53 pm

Expat,

Will 3.14 do it?

Michael Angelo Pagala · Posted: Fri Oct 29, 2010 1:58 pm

hi cima,

I am assuming you need only 1 output which list what is matched and not matched from the two files.

here is an untested code which I think can give the output you need.

steve6 · New User Joined: 10 Jul 2007 Posts: 7 Location: Chennai

I guess expat wanted to suggest 3.13 here.

However, I am not sure if we can mention multiple column ranges in the 'CMPCOLN & CMPCOLO' of 3.13 option.

looking at the sample data I suppose the comparision should happen on 2 column ranges. 1-4 & 9-12.

So my suggestion would be to use the MATCH facility of Eztrieve (if Eztrieve can be considered as an option here).

If MATCHED....
If FILE1....
If FILE2...
would lead you to the desired output.

Michael Angelo Pagala · Posted: Fri Oct 29, 2010 2:13 pm

by the way..I apologize for my post above..I gave a solution wherein I didn't know if the TS is using syncsort

sorry guys

expat · Posted: Fri Oct 29, 2010 2:15 pm

cima · New User Joined: 22 Mar 2006 Posts: 8

Hi Michael,

Thanks for the jcl code.. thats exactly what i was looking for..

Thanks guys for the help..

Grazias,
cima