READ_LOCK_TYPE=

READ_LOCK_TYPE=

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

Default value: DBMS specific

See Also: UPDATE_LOCK_TYPE=
READ_LOCK_TYPE= LIBNAME option

Syntax
Details

Syntax

READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK

ROW: locks a row if any of its columns are accessed.
PAGE: locks a page of data, which is a DBMS-specific number of bytes.
TABLE: locks the entire DBMS table.
NOLOCK: does not lock the DBMS table or any rows during a read transaction.

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. You can set a lock for one DBMS table by using the data set option or for all tables in a particular DBMS by using the LIBNAME statement option.

If you specify READ_LOCK_TYPE=TABLE, you must also specify 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.

See your DBMS chapter for details on the option values supported for your DBMS.

Chapter Contents
Previous
Next
Top of Page

Default value:	DBMS specific
See Also:	UPDATE_LOCK_TYPE= READ_LOCK_TYPE= LIBNAME option