RE: Row locks in DB2/400 UDB

Zak, 

Not true. See IDENTITY_VAL_LOCAL() at
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzms
tscale.htm

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: Metz, Zak [mailto:Zak_Metz@xxxxxx] 
Sent: Monday, August 11, 2003 1:00 PM
To: Midrange Systems Technical Discussion
Subject: Row locks in DB2/400 UDB


That's great, but you still don't know what key was assigned, so you
can't redisplay the posted record. As far as I can tell, the best way to
deal with this and get that important tidbit is by using a single
program issuing keys based on a data area value. If there's a non-DTAARA
way to do this, I'd love to know!

-Zak Metz

> -----Original Message-----
> From: E Doc
> Sent: Friday, August 08, 2003 11:47 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: MIDRANGE-L Digest, Vol 2, Issue 1212
> 
> 
> Rob sez:
>  
> If you are running V5R2, then abandon that technique and use 
> a datatype of 
> ROWID or identity columns to store your sequence number.
> http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst79.htm
> http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst80.htm
> All problems solved.
>
 
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.


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