Re: DB2

Would that be fixed by the rowid, or either the identity column, functions 
of V5R2?
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzahf/rzahfwhatsnew.htm

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"William Washington III" <w.washington3@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/13/2003 02:15 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     midrange-l@xxxxxxxxxxxx
        cc: 
        Fax to: 
        Subject:        Re: DB2


I agree with Joe.

The key idea (no pun intended) is "invariant." 
For a given key value, you should always access 
the same row.  If a delete and RGZPFM occurs, 
the deleted RRNs are compressed out and 
everything else is renumbered.  That will blow 
the invariant nature of the so-called key.

William

---- Begin Original Message ----
message: 10
date: Thu, 13 Mar 2003 13:02:59 -0600
 from: "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
subject: RE: DB2

> From: Booth Martin
>
> I am curious why you say this Joe?    Every 
physical file record
> can be accessed by relative record number

See my reply to Chris.  I'm pretty sure that RRN 
doesn't count because RRN
isn't a data element in the row.  You guys wuold 
have to ask Dr. Codd
whether the RRN can be used as a "primary key" 
in his definition.

My guess is it cannot.  Your guess is as good as 
mine, of course.

Joe



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.