Re: Locking records in DB2

[RPower@xxxxxxxxxx]

Ok I was thinking of using that, but I guess I'm not sure how I should 
approach it.  See here's the logic I need:
Lock Record
Show screen with locked record on it.
If user updates, update record, if they don't, just unlock it.
I'm using servlets and req and resp to produce the forms.
Do you have any examples of a similar process?

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




Franco Biaggi <fbiaggi@xxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
2005/10/04 03:06 PM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>
cc

Subject
Re: Locking records in DB2






Hi,
you may try with SELECT ... FOR UPDATE.

RPower@xxxxxxxxxx wrote:

>Can anyone help me with understanding what I need to do to use Java and 
>SQL to put a record lock on a database file on the iSeries?  I'm using 
>Java to create a web based application that will allow users to update, 
>review, change and delete records pertaining to our hardware maintenance 
>program.  I'm at a loss to do this, cause I'm not sure how SQL/Java locks 

>records in DB2?  Thanks,
>
>Ron Power
>Programmer
>Information Services
>City Of St. John's, NL
>P.O. Box 908
>St. John's, NL
>A1C 5M2
>709-576-8132
>rpower@xxxxxxxxxx
>http://www.stjohns.ca/
>___________________________________________________________________________
>Success is going from failure to failure without a loss of enthusiasm. - 
>Sir Winston Churchill
> 
>