Re: Best way to compare records

I did this once.

Sometimes, you need to get back to the caveman days, maybe archaic
methods. You can write a very simple RPG program, defining the original
file as the "source" file, which you will compare to the one as the
"target". Declare both files as internally defined in the program using the
record length. Declare the "source" file as the primary, IP, and the second
as IF. Every time you read a record from the primary file, immediately read
the record from the "target" file afterward. Since both files will provide
their data in blind buffers, simply compare them and create logic that will
allow you to detect when there is a difference in the two buffers.
Described like this, it may seem difficult, but actually doing it only
takes a few lines of code. You said you didn't want to code, but this
method is actually very effective. Give it some thought. It should run
very fast!

HTH
JS


El jue, 22 ago 2024 a las 5:18, Rob Berendt (<robertowenberendt@xxxxxxxxx

)

escribió:

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.

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