LOCKTABLE= LIBNAME Option

Places exclusive or shared locks on tables.
Valid in: SAS/ACCESS LIBNAME statement
Default: no locking
Data source: Informix
See: LOCKTABLE= data set option

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.