Data Set Options for Relational Databases |
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 |
locks a table exclusively, preventing other users from accessing any table that you open in the libref.
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.