Set the UseCursor connection property to determine whether the client-side or the server-side scrollable cursors are used.
When the UseCursor connection property is 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 0, client-side scrollable cursors (cached result sets) are used, regardless of the Adaptive Server version.