Need to get values which are diff b/w 2 files

ganesh_al · New User Joined: 06 Sep 2006 Posts: 1 Location: USA

Hi

here is my requirement..! I have two files in hand.. I want to compare these two files and get a report as output which should show the key - followed by value which is different in file1 and value in file2.

Here is the example:
File 1 data
123ABC 123456
123DEF 123789

File 2 Data
123ABC 123456
123DEF 123456

Here first 6 characters are key. Followed by that I have data..
Now I wish to have my output as - Key - followed by first file's data which was different and then second file data's which was different..
123DEF 789 456

Frank Yaeger · Posted: Thu Sep 22, 2011 4:05 am

You show only one example with different data. I can think of many different variations but you haven't given clear rules for all of those variations. It also isn't clear if you're comparing the two files key by key or record by record, or whether you have duplicate records within a file?

Here are some other possible input examples that you haven't covered - there are many more.

Bill Woodger · Posted: Thu Sep 22, 2011 4:13 am

ganesh_al,

It looks more like what you want is a file-comparison utility. Find out what you have available, look at the manuals, try it out.

Escapa · Posted: Thu Sep 22, 2011 3:30 pm

Hi, Welcome...

With examples you have shown, one might think you are matching chunks of 3 characters at a time like 123 with 123, 789 with 456...

Show the expected output for example shown by Frank.

What is LRECL\RECFM of input files

What is sort product installed at your shop?
(If you are not aware how to find .. Follow link ibmmainframes.com/viewtopic.php?t=33389 )