Scrollable Cursors

Scrollable cursors can go backward as well as forward to more easily support screen-based applications.

When a user scrolls backward and forward, the backend provides the corresponding data.

• Setting the UseCursor Connection Property
  Set the UseCursor connection property to determine whether the client-side or the server-side scrollable cursors are used.
• Static Insensitive Scrollable Cursor Support
  The Adaptive Server ODBC Driver supports the Static Insensitive scrollable cursor. The Static Insensitive implements the ODBC SQLFetchScroll method to scroll and fetch rows.
• Scrollable Cursor Attributes
  The scrollable cursor attirbutes in the Adaptive Server ODBC Driver.
• Executing Scrollable Cursors
  Use SQLBindCol() and SQLFetchScroll() APIs to execute a scrollable cursor.
• View Results
  View results after executing a scrollable cursor, assuming a total of N rows and a rowset m where N > m.
• Scrollable Cursor Attributes Set Implicitly
  Certain attributes are set implicitly when your application sets specific attributes.