Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

DataSourceBlockFetchForUpdate

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

When the isolation level is Read Committed and a SELECT FOR UPDATE statement is issued against some data stores, the OpenAccess SDK Client does not lock the expected row.

Valid values

0 | 1

  • 0=The appropriate row will be locked. Specifying 0 degrades the performance for SELECT FOR UPDATE statements because rows are fetched one at a time.
  • 1=The appropriate row is not locked.

Default

1

Type

Dynamic

For more information about isolation levels, refer to the OpenAccess SDK Client Reference.

TitleResults for “How to create a CRG?”Also Available inAlert