Re: [ EXTERNAL ] Re: Does an Relative Record number ever change

RRN may change on some records if the table is RGZPFM'ed (depending upon
the option selected).



On Wed, Feb 2, 2022 at 9:51 AM Ken Meade <kmeade@xxxxxxxxxxxxxxxxx> wrote:

Thanks Charles. Have a meeting with the team in just a few minutes, will
be forwarding this to them as a discussion point.

We had talked about adding a key to the current PF, but that would have
meant recompiling.

Ken


----- Original Message -----
From: "Charles Wilt" <charles.wilt@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxxxxxxxx

Sent: Wednesday, February 2, 2022 12:47:55 PM
Subject: [ EXTERNAL ] Re: Does an Relative Record number ever change

hit enter to quick...

You can replace the current PF with a new SQL table with a generated
identity key.

Change the existing PF to be a logical pointed at the new table.
Change existing LF to point to the new table and have an explicit list of
columns without the identity (if they aren't already).

Done properly, none of your existing RPG program even need a recompile.

The "Modernizing IBM i Applications from the Database up to the User
Interface and Everything in Between" Redbook goes into more detail on how
to do this.
https://www.redbooks.ibm.com/abstracts/sg248185.html?Open

Also been discussed multiple times on this list (and/or the RPG list)

Charles


On Wed, Feb 2, 2022 at 10:40 AM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

RRN can change on a re-org...

RRN can be re-used if Reuse Deleted Records is *YES

Charles

On Wed, Feb 2, 2022 at 10:36 AM Ken Meade <kmeade@xxxxxxxxxxxxxxxxx>
wrote:

All,

We are using an audit tool that pulls from our journal and then outputs
to a file. Usually we are good to go, but this time I see that we don't
have this file keyed in a way that we can easily tie out to it.
We can build a view use the RRN as that is captured in the file and

tying

out to the RRN in the primary file and capture a key field(s), but the
question came up as to would the RRN in the primary file ever change if

we

did a Reorg on the file or if the file is set up to reuse deleted

records?

Thanks,
Ken M.





Ken Meade | Director of Information Technology


[ mailto:kmeade@xxxxxxxxxxxxxxxxx | kmeade@xxxxxxxxxxxxxxxxx ] | (603)
444-3570





Littleton Coin Company, Inc.


1309 Mt Eustis Rd, Littleton NH 03561


[ http://www.littletoncoin.com/ | www.littletoncoin.com ]












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

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

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

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
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.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com