RE: DB2

I am curious why you say this Joe?  

Every physical file record can be accessed by relative record number, always
  

If my program is using various logicals over a physical I only do adds,
deletes, and updates by RRN against the physical file.   If the physical
happens to be keyed I leave off the K in the F-spec.  It saves a ton of
coding, is fast, and avoids many issues of record locking.

---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Thursday, March 13, 2003 12:44:43
To: Midrange Systems Technical Discussion
Subject: RE: DB2
 
> From: Leif Svalgaard
>
> Criteria for Fully Relational

Rule 2, guaranteed access, is the primary rule that is broken and will
probably always be broken in DB2/400, because any non-keyed physical file by
definition fails. In most "true" RDBs, you'll see a special "row ID" field
that is used to provide a unique key to every row in the table; without
this, the database is not truly relational according to Codd.

Joe