Prior to Release 5.2, a row to be updated by a CHGOBJ function implemented in SQL was locked at the time the row was updated. As a result, it was possible for the row to be updated by another user between the time it was read (SELECT) and the time it was updated (UPDATE).
The SQL Locking (YSQLLCK) model value in Release 5.2 lets you specify whether a row to be updated will be locked at the time it is read or at the time it is updated. Note that locking the row at the time of the read requires that an SQL cursor be declared, which incurs performance penalties.
|
Copyright © 2014 CA.
All rights reserved.
|
|