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