Re: compare two files

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

-----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-----