Re: [EXTERNAL] Re: Quick question on file behavior

Maybe I'm getting in over my head, but reorgs and deleted records are not
going to change RRN sequencing. It can certainly change the sequence of
records read (RRNs change), but not the underlying sequencing
implementation.

On Fri, Jul 10, 2020 at 5:11 PM Alan Shore via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Has the file ever been re-orged (RGZPFM)?
How was it re-orged is then the question

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
‘If you're going through hell, keep going.’
Winston Churchill


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
Jim Oberholtzer
Sent: Friday, July 10, 2020 5:09 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Quick question on file behavior

Is reuse deleted records turned on, if so I highly doubt it.

What about a logical?

Jim Oberholtzer
Agile Technology Architects

On Jul 10, 2020, at 4:02 PM, James H. H. Lampert <

jamesl@xxxxxxxxxxxxxxxxx> wrote:

Ladies and Gentlemen:

I have a file that is *not* uniquely keyed (the designer is apparently

ideologically opposed to allowing the OS to enforce uniqueness).

In my general observations, it has always been my *impression* that if

I'm going through a file in keyed sequence, via native RLA, records with
duplicate keys are presented in RRN sequence. But I am not certain of that
(and conversely, everything I've read about SQL-only databases like MySQL
says that the sequence in which records with the same key appear in a
result-set is neither predictible nor even necessarily repeatable).

But this is strictly DB2/400, via native RLA: If I am "Riding The RPG

Cycle" through the file, and I hit two or more records with the same key,
*can* I reasonably expect them to appear in ascending RRN sequence?

--
JHHL
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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 RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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 RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-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