The scrollable cursor feature provides a way to set the current position anywhere in the result set by specifying a NEXT, PREVIOUS, FIRST, LAST, ABSOLUTE or RELATIVE clause in a FETCH statement. It implements a scrollable cursor that is read-only with either an INSENSITIVE or a SEMI_SENSITIVE property.
Open Client allows both scrollable and non-scrollable cursors. Scrollable cursors can be insensitive or semi_sensitive. Non-scrollable cursors in 15.0 can have an insensitive attribute. Pre-15.0 cursors have no sensitivity attributes.
Implementation uses either the old-style ct_fetch() API for non-scrollable cursors or insensitive non-scrollable cursors. A new function named ct_scroll_fetch() has been added to the API to cater to scrollable cursors. Both API allow for single or multi-row fetches.
No configuration options are required. During client login, a capability bit is tested to see if the connecting ASE supports scrollable cursors. If no support is available, the ct_scroll_fetch() API cannot be used; instead, the application must use ct_fetch() instead.
For more information on Client-Library scrollable cursors, see these documents:
Open Client 15.0 Client-Library/C Reference Manual
Open Client 15.0 Client-Library/C Programmer’s Guide
