Name
rnext — Get next result from a remote result set
Synopsis
integer retcode rnext ( |
in cursor_handle long , |
out row_array vector , | |
out sql_state varchar , | |
out sql_error varchar
) ; |
Description
Use rnext
in combination with
rmoreresults
to
iterate over a result set produced by a statement run in a remote
data source with rexecute
.
open a cursor with rexecute . |
loop over the results with rnext |
if rmoreresults does not return an error or SQL_NO_DATA_FOUND continue the loop with rnext, otherwise |
close the cursor with rclose |
Parameters
cursor_handle
The long cursor handle as obtained from rexecute.
row_array
An output vector that will contain the result columns.
sql_state
Optional varchar output parameter for SQL state.
sql_error
Optional varchar output parameter for any error message.
Return Values
All data is returned in output parameters.
See Also
rexecute
, rmoreresults
,
rclose
.