To determine whether the client-side or the server-side scrollable cursors are used, set the UseCursor property:
When the UseCursor connection property is set to 1 or 2, server-side scrollable cursors are used if Adaptive Server version is 15.0 or later. In earlier versions of the Adaptive Server, server-side scrollable cursors were not available. When the UseCursor connection property is set to 0, client-side scrollable cursors (cached result sets) are used, regardless of the Adaptive Server version.
WARNING! Using client-side scrollable cursors is resource-intensive.
When the UseCursor connection property is set to 0, client-side scrollable cursors (cached result sets) are used, regardless of the Adaptive Server version.
See 