UPDATE_LOCK_TYPE=

UPDATE_LOCK_TYPE=

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

Default value: DBMS specific

See Also: READ_LOCK_TYPE=
UPDATE_LOCK_TYPE= LIBNAME option

Syntax
Details

Syntax

UPDATE_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 row or table during an update transaction.

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 all tables in a particular DBMS by using the LIBNAME option.

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

Chapter Contents
Previous
Next
Top of Page

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