OAFETCH
oafetch retrieves rows and places them in buffer. The source of the rows
and the columns to be returned is established by oaselect.
oaqualify and oaselect designate rows for retrieval. The next call to
oafetch for the cursor initiates the retrieval of rows previously qualified
or selected. As a result, the area defined by buffer must match the layout
implied by the list of columns defined in the last successful call to
oaselect for the cursor.
Syntax
oafetch (cursor, options, status, num_rows, buffer)
cursor -- Is a 32-bit signed
integer passed by value. This is the value returned by a successful
call to oaopencursor.
options -- Is currently reserved
and must contain a semicolon or a null character passed by
reference.
status -- Returns information
about the success or failure of the oafetch routine. The status
structure is passed by reference and contains fourteen 32-bit
signed integers, followed by a 36-character buffer.
An End of data condition is returned as an error if you try
to fetch when no rows were selected. An End of data condition
is returned as a warning if the number of rows selected is
greater than zero but less than count.
count -- Contains the number
of row complexes (record complexes) to retrieve with oafetch.
Count is a 32-bit signed integer passed by value.
buffer -- Is a pointer to
a buffer area that receives the rows specified by the columns
parameter of oaselect. Binary data may require conversion
when rows are transferred from the server to a client. For
more information about byte-ordering, see byte ordering and
byte boundaries.
Buffer is ignored if oaselect was called with the COLUMN option.
You must then use oadescribe and oabind to establish the buffers
for each select item.
Options
Example
Top
|