196 LOCKTABLE= Data Set Option Chapter 10
Details
The location name maps to the location in the SYSIBM.SYSLOCATIONS catalog in the
communication database.
In the DBMS engine, the location is converted to the first level of a three-level table
name:
location-name.AUTHID.TABLE. The connection to the remote DBMS subsystem
is done implicitly by the DBMS when it receives a three-level name in an SQL
statement.
If you specify LOCATION=, you must also specify the AUTHID= option.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “LOCATION= LIBNAME Option” on page 105.
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)
DBMS support: Informix
Default value: LIBNAME setting
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, allowing other users or processes to read data from the
tables, but preventing users from updating data.
Details
You may lock tables only if you are the owner or have been granted the necessary
privilege. If you omit LOCKTABLE=, no locking occurs.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “LOCKTABLE= LIBNAME Option” on page 106.
