Try the following - off the top of my head
Select 'prodfiles/uxfd', a.* from prodfiles/ufxd a exception join qtemp/ufxd b on a.ufact = b.ufact
Will get you the records in prodfiles/ufxd that are not in qtemp/ufxd based upon a.ufact = b.ufact
And then build up from there
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Friday, February 06, 2015 12:43 PM
To: Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx)
Subject: finding differences between 2 files
Trying to identify
Records in file a not in file b
Records in file b not in file a
Records that match key but have any differences
This is what I'm trying
(select * from prodfiles/ufxd where ufact = ufact
except
select * from qtemp/ufxd )
union
(select * from qtemp/ufxd
except
select * from prodfiles/ufxd where ufact = ufact)
If this works as I think, I need to identify whether the results are in file a or file b
Not sure what to do
Thanks
Mike
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
