Previous Page | Next Page

The LIBNAME Statement for Relational Databases

LOCKTABLE= LIBNAME Option



Places exclusive or shared locks on tables.
Default value: no locking
Valid in: SAS/ACCESS LIBNAME statement
DBMS support: Informix

Syntax
Syntax Description
Details
See Also

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

Previous Page | Next Page | Top of Page