The LIBNAME Statement for Relational Databases |
Places exclusive or shared locks on tables.
Default value: |
no locking
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Informix
|
LOCKTABLE=EXCLUSIVE | SHARE
|
-
EXCLUSIVE
-
specifies that other users are prevented
from accessing each table that you open in the libref.
-
SHARE
-
specifies that other users or processes
can read data from the tables, but they cannot update the data.
You can lock tables only if you are the
owner or have been granted the necessary privilege.
To apply this option to an individual data set, see
the LOCKTABLE= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.