A_ODBC_LOCK_METHOD configuration variable

Use this variable to specify the locking method that the Database Connectors product should use when accessing your data source. Possible values are:

none
SETPOS
SETSTMTOPTION
UPDATECOLUMN

For example:

A_ODBC_LOCK_METHOD UPDATECOLUMN

The default value is none, meaning that the Database Connectors product will do nothing special to lock your data. This does not necessarily mean that your data won’t be locked. Locking depends mainly on your data source and driver. No value simply tells Database Connectors for ODBC not to perform any locking functions.

Note: Setting this variable may affect certain ODBC drivers. Locking depends mainly on the data source and the driver. You can use this variable to attempt to induce row locking. If none of the settings cause any rows to be locked, or if the machine stops responding, please report this behavior to Technical Services.