Notes
Locks obtained: Locking is used to prevent concurrent
operations.
The lock is released:
- When the unit of work ends, unless the unit of work is ended by a COMMIT
HOLD or ROLLBACK HOLD
- When the first SQL program in the program stack ends, unless CLOSQLCSR(*ENDJOB)
or CLOSQLCSR(*ENDACTGRP) was specified on the CRTSQLxxx command
- When the activation group ends
- When the connection is changed using a CONNECT (Type 1) statement
- When the connection associated with the lock is disconnected using the
DISCONNECT statement
- When the connection is in the release-pending state and a successful COMMIT occurs
You may also issue the Deallocate Object (DLCOBJ) command to unlock the
table.
Conflicting locks already held by other application processes will cause
your application to wait up to the default wait time of the job.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.