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



RRN is a great concept used in the 70s and early 80s, really before logical
files. The problem with RGZPFM is that it will change the location of the
record in the file. In a RRN direct access, when you want to read customer
number 6000, you read record 6000 and that is the correct record. If you do
a RGZPFM, then the record for customer number 6000 is no longer stored in
record 6000.

Whenever I find programs accessing records by RRN, I usually try to find the
programmer who wrote it and bring him/her up to the roof and throw him/her
off. In all seriousness, it was a very quick and efficient way to access
records before logical files. The big issue is when the "key" that you are
using on the RRN has large gaps in its value, then you will have the same
number of empty or deleted records between the real records.

Pete



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S. Waterbury
Sent: Monday, September 08, 2008 3:43 PM
To: Midrange Systems Technical Discussion
Subject: Re: Prohibit RGZPFM because of RRN access.

Hi, Rob:

So long as those RRNs are never stored anywhere else, (e.g. in any other
files, to "point to" records in this file), then what's the harm in
allowing a RGZPFM? I think RGZPFM requires "exclusive" access to the
file, so none of your applications can be actively using this file, when
the RGZPFM takes place; or the RGZPFM will get:

CPF3202 File XXXXXXXXXX in library YYYYYYYYYY in use.

So long as the application does not close the file, and "hang onto" any
RRNs, and then re-OPEN the file and expect the records to still be there
in the same place, you should be okay.

Or, am I missing something?

Mark

rob@xxxxxxxxx wrote:
If one routinely access a file by RRN is there a way to CHGPF or some such

thing to prohibit RGZPFM against that particular file?

Rob Berendt


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.