Sybase Adaptive Server Anywhere - Page 584

LOCK TABLE statement
566
♦
SQL/92 Vendor extension.
♦
Sybase Supported in Adaptive Server Enterprise. The WITH HOLD
clause is not supported in Adaptive Server Enterprise. Adaptive Server
Enterprise provides a WAIT clause that is not supported in Adaptive
Server Anywhere.
♦ The following statement prevents other transactions from modifying the
customer table for the duration of the current transaction:
LOCK TABLE customer
IN SHARE MODE
Standards and
compatibility
Examples