LOCKTABLE= LIBNAME Statement Option

Places exclusive or shared locks on tables.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Access
Default: no locking
Data source: Informix
See: LOCKTABLE= data set option

Table of Contents

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.

Last updated: February 3, 2026