RE: RRN Reletive record number question

It's been a while since I've worked with any application that relies on the physical order of records in a file. (For one, SQL retrieval order can be unpredictable unless the ORDER BY clause ensures uniqueness.)

That said, I don't think you can rely on records remaining in the same RRN/physical order doing a reorg. I would caution against testing this because your test reorg may just "get lucky" and reorg the records in the same arrival sequence, but subsequent reorgs might not. I presume that you are aware that RGZPFM has the KEYFILE parameter so that records are reorganized by that file's key.

- Dan

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Timothy Feldmeier
Sent: Thursday, April 4, 2024 11:10 AM
To: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
Subject: RRN Reletive record number question

I know the RRN can change when running a reorg, as it will reuse deleted records etc... My question is - would the order of the RRN every change for a record.
This would allow a program to keep the RRN order to be always reliable.

Thank You
Tim Feldmeier
*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***