RE: SQL Record Lock Question

More specifically,

What's the files wait time (WAITRCD on the CHGPF command).



Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
> Sent: Wednesday, January 18, 2006 3:35 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL Record Lock Question
> 
> 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.
> 
> 
> -- 
> 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.
> 
>