LOCKTABLE= Table Option

Places shared or exclusive locks on tables.

Category: Table Control
Data source: SAS data set

Syntax

LOCKTABLE= SHARE | EXCLUSIVE

Arguments

SHARE

locks a table in shared mode, allowing other users or processes to read data from the tables, but preventing users from updating data.

EXCLUSIVE

locks a table exclusively, preventing other users from accessing any table that you open.

Details

You can lock tables only if you are the owner or have been granted the necessary privilege.
If you access the BASE table driver through PROC FEDSQL, the default value for the LOCKTABLE option is EXCLUSIVE. However, if you access the BASE table driver through a SAS Federation Server, or if you run your program locally with the SAS Federation Server LIBNAME engine, the default value for the LOCKTABLE option is SHARE.
Last updated: February 23, 2017