The information given here on cursor options is only applicable to OpenESQL.
The behavior and performance of cursors can be tuned using the following embedded SQL statements:
The SET SCROLLOPTION statement selects how the row membership of the results set of a cursor is determined.
With concurrent access, data would soon become unreliable without some kind of control. To activate concurrency control, use the SET CONCURRENCY statement before the cursor is opened.
SET SCROLLOPTION and SET CONCURRENCY are part of the Extended SQL Syntax and are not supported by all ODBC drivers.