But what key? (was RE: Row locks in DB2/400 UDB)

I don't see how this helps. It's still a separate statement, so
additional inserts could have occurred in-between, and if I put it in
the Insert statement it gives me the last value inserted, not the one
currently being inserted. Doesn't seem "industrial strength," much like
a Select max()+1, then Insert. I hope I'm just missing something here.
Alas, my box doesn't run v5r2 anyway.

> -----Original Message-----
> From: Walden H. Leverich III
> Sent: Monday, August 11, 2003 1:43 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: 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?in
> fo/db2/rbafzms
> tscale.htm
 
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.