skip to main content
Using the ODBC Client : Specifying ODBC Connection Attributes : BlockFetchForUpdate
 

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