Cursors

Client-Library (server-side) cursors replace several types of DB-Library functionality:

• DB-Library cursors

  Client-Library (server-side) cursors are faster than DB-Library cursors. The Client-Library supports scrollable cursors wherein you can set the position of a cursor anywhere in the cursor result set. You can navigate forward or backward in the result set from a given current position, using either absolute or relative row number offsets into the result set. In addition, you can also use the fetch orientations like NEXT, FIRST, LAST, and PREVIOUS within the result set to select single rows for further processing.

• DB-Library browse mode

  Although Client-Library supports browse mode, cursors provide the same functionality in a more portable and flexible manner.

DB-Library applications that use cursors or browse mode can benefit from redesign to use Client-Library (server-side) cursors.