Places exclusive or shared locks on tables.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | LIBNAME option value |
| 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 |
Table of Contents
locks a table exclusively, preventing other users from accessing any table that you open in the libref.
locks a table in shared mode. It allows other users or processes to read data from the tables but preventing users from updating data.