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 UNIX/PC, MySQL, ODBC, Oracle, Teradata

Syntax

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 additional information, see the locking topic in the appropriate data source reference in the DataFlux Federation Server Administrator’s Guide.