RE: Best way to compare records

1. If you have 2 files and want to check if there are differences in the
data, you may work with merging Sub-Selects with EXCEPT and UNION (may run
some time because all rows and all columns are compared!)
Except will return everything that is in the first SELECT but not of
different in the second SELECT
Union will Merge the Results together
... The following query will return the differences between both files
( Select * from File1 ...
Except
Select * from File2 ...)
Union
( Select * from File2 ...)
Except
Select * from File 1...)

2. you may check the IBM Service COMPARE_FILE
https://www.ibm.com/docs/en/i/7.5?topic=services-compare-file-table-function

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
atl
Sent: Wednesday, 21 August 2024 20:12
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Best way to compare records

Is there a simple way to compare records in a file?
I need to find where a field changed and was wondering if there is a way
using SQL to identify changes?
I need to search several thousand records for where a field may have
changed.
I am harvesting the journals we have on all files.

Hoping I do not have to write code to achieve this.

TIA, Darryl Freinkel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.