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

["Metz, Zak" <Zak_Metz@xxxxxx>]

I was trying to test that assertion but I can't find a v5r2 box with SQL
around here. So please, where does the doc say that, cause I don't see
it.

> -----Original Message-----
> From: Walden H. Leverich III
> Sent: Monday, August 11, 2003 2:22 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: But what key? (was RE: Row locks in DB2/400 UDB)
> 
> 
> Nope. The function will return (baring bugs <G>) the value of the last
> insert _YOU_ did. It doesn't care about triggers or other jobs. 
> 
> -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 2:09 PM
> To: Midrange Systems Technical Discussion
> Subject: 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.