Data Set Options for Relational Databases |
Places exclusive or shared locks on tables.
Default value: |
LIBNAME setting
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Informix
|
LOCKTABLE=EXCLUSIVE | SHARE
|
-
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, allowing other
users or processes to read data from the tables, but preventing users from
updating data.
You can lock tables only if you are the
owner or have been granted the necessary privilege. If you omit LOCKTABLE=,
no locking occurs.
To assign this option to a group of relational
DBMS tables or views, see the LOCKTABLE= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.