Re: DB2

[Richard Reeve <richreeve@xxxxxxxxx>]

I sure didn't know that this simple question would exicite so many varied  
responses...:)

Thanks again.

 
 rob@xxxxxxxxx wrote: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" 
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" 
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.


_______________________________________________
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.





---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online