LOCKTABLE
Syntax
Command
Mandatory parameter Optional parameter Mandatory keyword Optional keyword |
LOCKTABLE (<Table> | <Alias>.<Table>)
Description
Places an exclusive lock on the specified table. This means that the specified table cannot be accessed by other users or by concurrent transactions, until the transaction for the specified table has ended. The lock can also be released by a COMMIT command within this transaction. A LOCKTABLE command always has to placed before performing the transaction on the specified table.
Diagram
Returned value type
None
Parameters
| Parameter | Description |
| <Alias> |
An alias of an other (external) database than the application database. |
| <Table> | Name of the table that has to be locked exclusively. |
Remarks
To prevent deadlock situations, you should only use this option in a transaction when this is really needed and make sure that this transaction is as short as possible.
Examples
locktable (users)
locktable (extdb.cuctomers)
locktable (extdb.cuctomers)