DB-Library fetch types and Client-Library cursors

dbcursorfetch supports a variety of fetch types. The following table lists dbcursorfetch fetch types and their Client-Library equivalents, if any:

Table 6-3: dbcursorfetch fetch types and their Client-Library equivalents

dbcursor Fetch Type

Client-Library Equivalent

FETCH_FORWARD

ct_fetch

FETCH_FIRST

Client-Library does not provide a direct equivalent. Instead, close and reopen the Client-Library cursor.

FETCH_PREVIOUS

Client-Library does not provide an equivalent option for backward scrolling.

FETCH_RANDOM

Client-Library has no equivalent for these fetch types, which apply only to keyset-driven DB-Library cursors.

If the keyset is not too large, a Client-Library application can substitute array binding with an array size equivalent to the dbcursoropen keyset size.

FETCH_RELATIVE

FETCH_LAST