Scrollable Cursor Support in ODBC
Support for static (read-only) and keyset-driven (updatable) cursor types are added to the Ingres ODBC driver. These cursor types allow the cursor to be positioned in any direction within a result set.
Static and keyset-driven cursors support the following position directives:
• SQL_FETCH_NEXT - fetch the next record in the result set
• SQL_FETCH_FIRST - fetch the first record in the result set
• SQL_FETCH_LAST - fetch the last record in the result set
• SQL_FETCH_PRIOR - fetch the previous record in the result set
• SQL_FETCH_ABSOLUTE - fetch a record based on the position in the result set
• SQL_FETCH_RELATIVE – fetch relative to n rows from the current position in the result set
In contrast, forward-only cursors support only SQL_FETCH_NEXT.
Static and keyset-driven cursors can be used only if the target database is Ingres 9.2 and later. For Ingres databases prior to 9.2, the Cursor Library can be used to simulate these types of cursors.
The Ingres ODBC driver now supports the SQLSetPos() function, which works for keyset-driven cursors only. SQLSetPos() allows the ODBC application to scroll the cursor to an absolute position within the result set and perform updates or deletes on the selected record.
For details, see the Connectivity Guide.