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

Syntax

Syntax Description

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, because of 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 more information, see the locking topic in the appropriate data source reference in SAS Federation Server: Administrator’s Guide.