BlockFetchForUpdate

Attribute

BlockFetchForUpdate (BFFU)

Description

Specifies a workaround connection attribute. When the isolation level is Read committed and a SELECT FOR UPDATE statement is issued against some data stores, the ODBC Client does not lock the expected row.

Valid Values

0 | 1

If set to 1, the appropriate row is not locked.

If set to 0, the appropriate row is locked.

Note: Specifying 0 degrades the performance for SELECT FOR UPDATE statements because rows are fetched one at a time.

Default

1