UPDATE_LOCK_TYPE=

UPDATE_LOCK_TYPE=

Specifies how an OLE DB table is locked during an UPDATE operation

Default value: ROW

Option type: LIBNAME and Data set

Syntax
Details
See Also

Syntax

UPDATE_LOCK_TYPE=ROW

Details

The UPDATE_ISOLATION_LEVEL= option applies only when updating a DBMS table or view. The value ROW specifies that a row or set of rows will be locked. To determine which rows will be locked, SAS/ACCESS software uses the UPDATE_ISOLATION_LEVEL= option.

For a full description of this option, refer to UPDATE_LOCK_TYPE= .

See Also

READ_LOCK_TYPE=

Chapter Contents
Previous
Next
Top of Page