Row locks in DB2/400 UDB

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

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/rb
> afymst79.htm
> http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rb
> afymst80.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.