LOCK TABLE

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
LOCK TABLE	YES	YES

Note: YES indicates a valid execution method for this statement. For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

CA Datacom/DB provides the LOCK TABLE statement as an extension so you can acquire a shared or exclusive lock on the named table. The table lock is acquired when the LOCK TABLE statement is executed. The table lock is released at the next commit point.

With regard to table partitioning, a LOCK TABLE statement can receive a CA Datacom/DB return code of 01(034) if it attempts to use a Any Parent table. See the CA Datacom/DB Message Reference Guide for details about return code 01(034). Information about table partitioning can be found in the CA Datacom/DB Database and System Administration Guide.

Following is the syntax diagram for the LOCK TABLE statement:

►►─ LOCK TABLEtable-nameIN ─┬─ SHARE ─────┬─ MODE ────────────────────────────►◄
                            └─ EXCLUSIVE ─┘