× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2024

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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.