Contents Index Fetching multiple rows Modifying rows through a cursor

ASA Programming Guide
  Using SQL in Applications
    Working with cursors

Fetching with scrollable cursors


ODBC and embedded SQL provide methods for using scrollable cursors and dynamic scrollable cursors. These methods allow you to move several rows forward at a time, or to move backwards through the result set.

The JDBC and Open Client interfaces do not support scrollable cursors.

Prefetching does not apply to scrollable operations. For example, fetching a row in the reverse direction does not prefetch several previous rows.


Contents Index Fetching multiple rows Modifying rows through a cursor