Re: Best way to compare records

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

But going back to your original question:  How to compare files.
I think there's a UNION or something I've seen where two files are compared
and will show you inserts, deletes modifications.
As far as from whom, when, where that's not part of that equation.

On Wed, Aug 21, 2024 at 2:12 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

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