RE: Which of the SYSIBM tables/views show the row count for

["Evan Harris" <spanner@xxxxxxxxxx>]

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.