Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Transactions and Isolation Levels » How locking works » Table locks

Table locks Next Page

Shared table locks

A shared table lock can be acquired explicitly through the use of the LOCK TABLE ... IN SHARED MODE statement. When a transaction acquires a shared table lock, that transaction can prevent changes from being made to the table until the transaction completes. Any number of transactions can hold shared table locks on the same table.