Re: Best way to compare records

I'm curious about the comparison of r-1 with r. Are these both journal
receiver rows?
Is this something which might be served instead by
STRJRNPF IMAGES(*BOTH)
and then there will be two DS in the journal receiver: The old row and the
new row. And these would be in the same receiver entry

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

I will be building the file from the journal receivers. I have my own
utility to build the fields from the receiver.

I am trying to compare record n-1 with record n.

Darryl.


On Wed, Aug 21, 2024 at 3:09 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

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.

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

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