UNLOCK TABLE is used in multi-user versions to release table locks acquired using the LOCK TABLE command.
Restriction: This topic applies to Windows environments only.
Invocation
UNLOCK TABLE is an executable command that can be issued interactively or embedded in a host language. UNLOCK TABLE can be dynamically prepared.
Authorization
You must be the user who locked the table.
Syntax
UNLOCK TABLE table-name
Parameters:
|
table-name
|
Identifies the table or view that was locked using a LOCK TABLE command. |
Description
The UNLOCK TABLE command is available in both single and multi-user environments; however it is effective only in multi-user environments.
All table locks acquired by the user with the LOCK command can be held until COMMIT or ROLLBACK is issued. If a table is locked in Exclusive Use mode, no record level locks will be recorded by the system. Be sure to COMMIT or ROLLBACK before unlocking a table that has an Exclusive Use lock. Otherwise, uncommitted changes to the database may be lost.