Previous Page | Next Page

Data Set Options for Relational Databases

LOCKTABLE= Data Set Option



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

Syntax
Syntax Description
Details
See Also

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 can 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 LOCKTABLE= LIBNAME Option.

Previous Page | Next Page | Top of Page