UseCursor Connection Property

The UseCursor connection property determines the type of cursor generated by the Adaptive Server ODBC Driver.

Adaptive Server ODBC Driver creates either of the two types of cursors, when a SQL statement that generate result sets is executed:

Server-side cursors – uses more resources, but is required to fully support cursor semantics.
Client-side cursors – uses less resources and is adequate for most use cases.

Valid values are:

0 – (default) Client-side cursors are used for all statements that generate result sets.
1 – Server-side cursors are used for all statements that generate result sets.
2 – Server-side cursors are used for all statements that generate result sets only when the SQLSetCursorName ODBC function is called. Use this setting to limit use of server-side cursors only for situations that require them.

Note: Depending on the other cursor attribute settings, a server-side cursor request may implicitly be changed by the Adaptive Server ODBC Driver to a client-side cursor.