Re: Logical file access paths

Hi Lewis,

That method dates back to when a program was not allowed to change a key
field. The drawback is you end up with a bunch of deleted records in the
file unless they are all set to re-use deleted records (a relatively recent
innovation<g>) or do a regular RGZPFM.

I hear MAPICS apparently uses a similar technique and has a large ratio of
deleted to active records in their files. One of my customers recently had
to do some mass updates to large files and during testing discovered that
hey! 70% of this 3 million record file is deleted records.

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


From: Lewis Libman <LLibman@behr.com>
> When I have to change the key in a logical file I would save the record
with the new key, delete the old record and add the new.


> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---