SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-229
UNLOCK TABLE Statement
UNLOCK TABLE Statement
Considerations for UNLOCK TABLE
Examples of UNLOCK TABLE
The UNLOCK TABLE statement releases locks owned by MXCI on a nonaudited
SQL/MP table or on underlying nonaudited SQL/MP tables of a view. UNLOCK TABLE
does not affect audited tables. Ending a transaction unlocks an audited table.
UNLOCK TABLE is an SQL/MX extension.
table
is the name of the table or view to unlock. See Database Object Names on
page 6-12.
Considerations for UNLOCK TABLE
Authorization Requirements
To unlock a table, you must have authority to read the table. To unlock a view, you
must have authority to read the view but not necessarily the tables underlying the view.
Examples of UNLOCK TABLE
•
Lock and unlock a nonaudited table within an MXCI session:
LOCK TABLE persnl.job
IN EXCLUSIVE MODE;
--- SQL operation complete.
DELETE FROM persnl.job
WHERE jobcode NOT IN
(SELECT DISTINCT jobcode
FROM persnl.employee);
--- 1 row(s) deleted.
UNLOCK TABLE persnl.job;
--- SQL operation complete.
UNLOCK TABLE table