skip to main content
IP API Reference for Java : Statement-level Methods for Java : sqlipFetchRow
 

sqlipFetchRow

This method fetches data at the current cursor position and advances the cursor to the next row of the result table. If no more rows are available, then return OADS_NO_DATA. Return OADS_BUFFER_FULL to indicate that all rows from current block have been returned; then, on the next call, start retrieving the next block. Typically, the IP is called with fetchRow and then with getColval for each column to retrieve the data.
Implement the optional sqlipFetchRowsInBuffer method for transferring blocks of rows from the Java layer to the OpenAccess SDK native layer.
int sqlipFetchRow();
 
Table 86: Parameters for sqlipFetchRow
Parameter
Type
Description
RETURN
 
 
 
int
OADS_SUCCESS – valid row fetched and the cursor has been moved to the next row.
OADS_BUFFER_FULL – indicates that all rows from the current block have already been returned. No row is returned and the cursor is not advanced.
OADS_NO_DATA – no more data available
OADS_ERROR – error fetching a row

See also 

• sqlipFetchRowsInBuffer