READ_LOCK_TYPE= Data Set Option

Specifies how data in a DBMS table is locked during a read transaction.

Valid in:	DATA and PROC steps
Default:	DBMS-specific
Supports:	DB2 UNIX/PC, MySQL, ODBC, Oracle, Teradata

Syntax

Details

Syntax

READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW

Syntax Description

TABLE: locks the entire DBMS table. If you specify READ_LOCK_TYPE=TABLE, you must also specify the LIBNAME statement option CONNECTION=UNIQUE, or you will receive an error message. Setting CONNECTION=UNIQUE ensures that your table lock is not lost, for example, due to another table closing and committing rows in the same connection. (This value is valid in DB2 under UNIX and PC hosts, ODBC, Oracle, and Teradata interfaces.)

NOLOCK: does not lock the DBMS table, pages, or any rows during a read transaction. (This value is valid in the Oracle interface and in the ODBC interfaces when you use the Microsoft SQL Server driver.)

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

Details

If you omit READ_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.

For additional information, see the locking topic in the appropriate data source reference in the DataFlux Federation Server Administrator’s Guide.