Hi Mike

As I understand it, I can ensure that a physical file is read in sequential
order either by specifying an appropriate OVRDBF or leaving off the K in the
F Specs in an RPG program. It makes no difference whether a key is specified
on the table definition.

Or am I missing something ?

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Tuesday, 11 March 2008 11:53 a.m.
To: 'Midrange Systems Technical Discussion'
Subject: RE: Which of the SYSIBM tables/views show the row count for

This may be a left over from the old days but we never put a key on any
table (Physical file) directly but just about every table (Physical file)
had a view/index (logical file) that has a unique key defined over that
table (PF). In some cases we have multiple views/indexes (LFs) with a unique
key defined over a table (PF). If I want to access a table and read it
beginning to end and do not need it in any sequence the fastest access is to
use the un-keyed table (PF). If I need to access the table in a known
sequence or pull a subset of data with a selected partial key I use the
appropriate keyed access file.


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].