Re: compare two files

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

with a (file, lib, id, fldn, count) as (
  select rffile, rflib, rfid, rffldn, recordcount
  from file1 ),
b (file, lib, id, fldn, count) as (
  select rffile, rflib, rfid, rffldn, recordcount
  from file2 )
select a.* from a
exception join b
  on b.file = a.file
 and b.lib = a.lib
 and b.id = a.id
 and b.fldn = a.fldn
 and b.count = a.count

That will output all of the rows in file1 that don't have an exact match
in file2

Then reverse the a and b in the subqueries and rerun to produce all of
the rows in file2 that don't have an exact match in file1.

Pete Hall
pbhall@xxxxxxxxxxxxx
http://pbhall.us


donna lester wrote:

I have FILE1,FILE2 each with 5 similar(Type and attributes are same) columns.
  Both are non-key physical files.
  Without writing RPG , I want to compare the data each record  in these two 
files and any difference in the respective columns  I want to write in detail 
to the user in the form of a file or spool or etc.
  rffile,rflib,rfid,rffldn,recordcount      are the 5 fields in both  FILE1 & 
FILE2.
  Both files expected to have same data and same number of records. 
   
  Thanks for your help!

  donna.
         


Thanks,

Donna.
 
---------------------------------
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF55V2pcZsDl8OX6kRAivOAJ9WnVoR6xmVJDvWRbW8eB/C+GJYXgCfU8BH
JgBhZKgQKGIdSeH4RuPxVlQ=
=CjAr
-----END PGP SIGNATURE-----