RE: SQL Record Lock Question

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

Nick,

What's your job's wait time. I would think the program would "hang" for
the wait time to see if the job that held the lock released it. If
that's 30 or 60 seconds, your app would appear "hung" during that time.

-Walden 


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

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


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Nick W. Mart
Sent: Wednesday, January 18, 2006 2:48 PM
To: RPG400 Mailing List
Subject: SQL Record Lock Question

With the help of several old posts, I have been able to get a record
lock when trying to update a record. Thanks to the list members for
that.

 

However, I have not been able to find how to handle when another user
tries to update this same record. So far, the program seems to hang when
it attempts to select the record for update. I attempted to use a
"whenever sqlerror goto recordlock" statement. However, that did not
seem to work.

 

Any and all suggestions would be welcome. Thank you in advance.

 

Nick W. Mart

Programmer Analyst

Solutions, Inc.

2311 West 18th Street

PO Box 857

Spencer, IA 51301

 

712-262-4520  ext. 33

 

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.