Locking Duration (Magic xpa 2.x)

A data lock is acquired at some time during the lifetime of a transaction and is withheld until a COMMIT or ROLLBACK command is initiated. Locks are not released during a transaction.

Example:

begin transaction;
update table set fld1= 1 where fld2= 2
update table set fld1= 3 where fld2= 4

both records are locked with an exclusive lock

commit;

both records are released.