Controls use of the ODBC's Cursor Library. The Cursor Library can provide support for scrolling cursors when the underlying driver doesn't, and can also allow "simulated" positioned updates. With USECURLIB=YES, the Cursor Library will always be used. With USERCURLIB=NO, it will never be used. With the default USERCURLIB=IFNEEDED, it will be used if the application tries to do something the driver manager thinks the driver doesn't support. To use a scrolling cursor with the Cursor Library, you must use a STATIC cursor. To do positioned updates using the Cursor Library, you must use OPTCCVAL concurrency.
Note:
A "simulated" positioned update might hit more than one row. We recommend including the primary key in the select for this reason.
Syntax:
USECURLIB={NO | YES | IFNEEDED}
NOUSECURLIB
Properties:
Default: |
USECURLIB=IFNEEDED |
Scope:
Used at compile time:
|
No
|
Behavior at run time:
|
Process
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.