RE: SQL Question On Record Locks

OK thanks for the info.  I'll take a look at the manual too, thanks.

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




"Wilt, Charles" <CWilt@xxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
17/05/2005 04:52 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: SQL Question On Record Locks






> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Wilt, Charles
> Sent: Tuesday, May 17, 2005 3:10 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL Question On Record Locks
> 
> 
> Ron,
> 
> As with RPG, the answer is it depends.
> 
> With RPG, it depends on if commitment control is used and if 
> so, what LCKLCL is used on the STRCMTCTL command.
> 
> Since SQL always uses commitment control, it simply depends 
> on the lock level used.

Last reply on this.... <grin>

What I was trying to point out is that SQL works the same as RPG.

Locking is a function of the DBMS, doesn't matter if you are using RPG or 
SQL to access the data.


HTH,
Charles

-- 
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.