LOCKTABLE= Data Set Option
Places exclusive or shared locks on tables.
| Valid in: |
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
|
| Default: |
LIBNAME setting |
| Restriction: |
If you omit LOCKTABLE=, no locking occurs. |
| Requirement: |
You can lock tables only if you are the owner or have
been granted the necessary privilege.
|
| Data source: |
Informix |
| See: |
LOCKTABLE= LIBNAME option |
Syntax
LOCKTABLE=EXCLUSIVE | SHARE
Syntax Description
- EXCLUSIVE
-
locks a table exclusively,
preventing other users from accessing any table that you open in the
libref.
- SHARE
-
locks a table in shared
mode. It allows other users or processes to read data from the tables
but preventing users from updating data.