rnext
Get next result from a remote result set
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.