UPDATE_LOCK_TYPE= Data Set Option

Specifies how data is locked during an update transaction.

Valid in:	DATA and PROC steps
Default:	LIBNAME statement setting
Supports:	DB2 under UNIX and PC, MySQL, ODBC, Oracle, Teradata

Syntax

Syntax Description

Details

Syntax

UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW

Syntax Description

TABLE

locks the entire table. (This value is valid in DB2 under UNIX and PC hosts, ODBC, Oracle, and Teradata data sources.)

NOLOCK

does not lock the table, page, or any rows when reading them for update. (This value is valid in the ODBC, and Oracle data sources.)

VIEW

locks the entire DBMS view. (This is valid in the Teradata interface.)

Details

If you omit UPDATE_LOCK_TYPE=, you get either the default action for the DBMS that you are using, or a lock for the DBMS that was set with the LIBNAME statement. You can set a lock for one DBMS table by using the data set option or for a group of DBMS tables by using the LIBNAME statement option.

For more information, see the locking topic in the appropriate data source reference in SAS Federation Server: Administrator’s Guide.