106 LOCKTABLE= LIBNAME Option Chapter 9
you access a DB2 table. If you specify LOCATION=, you must also specify the
AUTHID= option.
See Also
To apply this option to an individual data set, see the data set option “LOCATION=
Data Set Option” on page 195.
LOCKTABLE= LIBNAME Option
Places exclusive or shared locks on tables
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
Informix
Default value:
no locking
Syntax
LOCKTABLE= EXCLUSIVE | SHARE
Syntax Description
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.
Details
You may lock tables only if you are the owner or have been granted the necessary
privilege.
See Also
To apply this option to an individual data set, see the data set option “LOCKTABLE=
Data Set Option” on page 196.
LOCKTIME= LIBNAME Option
Specifies the number of seconds to wait until rows are available for locking
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: Informix
