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 .