You can use the UseCursor connection string property of Adaptive Server Enterprise ODBC Driver to determine how server-side cursors are used for SQL statements that generate result sets.
This property has been updated to allow a client application to control which statements create server-side cursors (value 2).
0 – the default value. Server-side cursors are not used.
1 – server-side cursors are used for all statements that generate result sets.
2 – server-side cursors are used for statements that generate result sets only when the SQLSetCursorName ODBC function is called. Because cursors use more resources, this setting allows you to limit the use of server-side cursors to statements that benefit from them.