Scrollable cursors allow applications to set the current position of the cursor anywhere in the result set by specifying appropriate scrolling options. Applications can use one of NEXT, PRIOR, FIRST, LAST, RELATIVE, or ABSOLUTE scrolling options to traverse the result set as desired.
Beginning with this release, Adaptive Server provides native support for static insensitive scrollable cursors on the server.
In this release, ASE ODBC and OLE DB Drivers can also use these server-side scrollable cursors. Server-side scrollable cursors are more efficient in the use of network and memory resources as compared to client-side scrollable cursors.
Server-side scrollable cursors can be used by the ASE ODBC and OLE DB Drivers when the following conditions are met:
You are connected to Adaptive Server 15.0 or later.
The UseCursor connection property is set to 1.
