RE: SQL Question On Record Locks

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

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