DB-Library fetch types and Client-Library cursors

dbcursorfetch supports a variety of fetch types. Table 6-3 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 or ct_scroll_fetch with fetch orientation (or type) set as CS_NEXT

FETCH_FIRST

ct_scroll_fetch with fetch orientation (or type) set as CS_FIRST

FETCH_PREVIOUS

ct_scroll_fetch with fetch orientation (or type) set as CS_PREV

FETCH_RANDOM

ct_scroll_fetch with fetch orientation (or type) set as CS_ABSOLUTE

FETCH_RELATIVE

ct_scroll_fetch with fetch orientation (or type) set as CS_RELATIVE

FETCH_LAST

ct_scroll_fetch with fetch orientation (or type) set as CS_LAST