Databases Without Transactions

In a database that was created without transactions, table locks that were set by the LOCK TABLE statement are released after any of the following events:

• An UNLOCK TABLE statement executes.
• The user closes the database.
• The user exits the application.

To change the lock mode on a table, release the lock with the UNLOCK TABLE statement and then issue a new LOCK TABLE statement.

The following example shows how to change the lock mode of a table in a database that was created without transactions:

LOCK TABLE orders IN EXCLUSIVE MODE
   . . .
UNLOCK TABLE orders 
   . . .
LOCK TABLE orders IN SHARE MODE