dbcursorfetch supports a variety of fetch types. The following table lists dbcursorfetch fetch types and their Client-Library equivalents, if any:
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 |