Using Keyset-Driven Scrollable Cursors

A keyset-driven scrollable cursor can be used if the driver is used with a third-party SQL engine that supports the ability to identify unique rows, such as a rowid column.

• The ODBC driver does not support using keyset-driven cursors on stored procedures or explicit batches.
• The ODBC driver cannot use keyset-driven cursors when the Select statement contains any of the following SQL language constructions:
  • JOIN
  • Aggregate functions
  • GROUP BY