RE: PF without key

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
The ruling used to be that for physical files with a small amount of data,
that there was not a problem with them being keyed, but physical files
with a significant amount of records, ie transaction files, should not be
keyed, due to the system resource required when for instance restoring.
Whether this still stands up with today's machines is another matter!




"Bartell, Aaron L. (TC)" <ALBartell@taylorcorp.com>
Sent by: rpg400-l-admin@midrange.com
10/10/2002 14:19
Please respond to rpg400-l


        To:     "'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
        cc:
        Subject:        RE: PF without key


Keith,

>If it's a database file then it's better to keep the PF as a data
repository and
>access records via a logical view; probably a logical file (LF) but
possibly SQL
>or OPNQRYF - as already mentioned.

I have always wondered why people don't want their Physical Files Keyed,
and
since you seem to be an advocate maybe you could explain your reasons.  I
am
not saying you are wrong, I am just curious.

Thanks,
Aaron Bartell
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.