UNLOCK TABLE

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.