LOCK TABLE statement [CR 379695]

The LOCK TABLE statement is allowed but undocumented in Sybase IQ 12.6. This statement prevents other concurrent transactions from accessing or modifying a table. Syntax is:

LOCK TABLE table-name [WITH HOLD] IN {SHARE | EXCLUSIVE}
MODE

Parameters are:

table-name - Must be a base table, not a view.

WITH HOLD — Holds the lock until the end of the connection. Otherwise, releases the lock when current transaction is rolled back or ends.

SHARE mode — Other transactions cannot modify the table but have read access. Requires SELECT privileges.

EXCLUSIVE mode — Other transactions cannot execute queries, updates, or any other transaction against the table. Requires DBA authority or ownership of the table.

This statement blocks or delays other transactions that may require access to the table. LOCK TABLE allows direct control over concurrency at a table level, independent of isolation level.