LOCKTABLE=

LOCKTABLE=

Places exclusive or shared locks on tables.

Default value: NONE

Syntax
Details

Syntax

LOCKTABLE=EXCLUSIVE | SHARE

EXCLUSIVE: locks a table exclusively.
SHARE: locks a table in shared mode.

Details

You may lock tables only if you are the owner or have been granted the necessary privilege. If you omit LOCKTABLE=, no locking occurs. LOCKTABLE=EXCLUSIVE prevents other users from accessing each table that you open in the libref. LOCKTABLE=SHARE allows other users or processes to read data from the tables, but does not allow them to update data.

LOCKTABLE= can also be specified with the TABLELOCK= alias.

Chapter Contents
Previous
Next
Top of Page