Scrollable cursors in DB2 ODBC

Scrollable cursors let you move backward and forward in a query result set.

The ability to scroll back and forth in a result set is essential for applications that need to return to previously fetched rows. Without scrollable cursors, those applications need to implement expensive, cumbersome methods for accessing fetched data again, such as closing and reopening cursors, or caching result sets. Because there is a performance cost for scrollable cursors, you should define scrollable cursors only when your applications require them.