UPDATE_LOCK_TYPE=

UPDATE_LOCK_TYPE=

Specifies how an ODBC table is locked during an UPDATE operation

Default value: ROW

Syntax
Details
See Also

Syntax

UPDATE_LOCK_TYPE=ROW | NOLOCK

Details

The value ROW specifies that a row or set of rows will be locked. The UPDATE_ISOLATION_LEVEL= option is used to determine which rows will be locked.

The value NOLOCK specifies that there is no locking on the table when it is read for update. Although NOLOCK is allowed, not all ODBC drivers support this option. In this case, an error will be printed.

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

See Also

READ_LOCK_TYPE=

Chapter Contents
Previous
Next
Top of Page