SE_stream_fetch

Fetches the next row on the specified stream

Usage syntax

LONG SE_stream_fetch (SE_STREAM stream);

Parameters
stream The stream handle
Description

SE_stream_fetch fetches a row of data for the specified stream. SE_stream_fetch retrieves the results from either SE_stream_query, SE_stream_query_logfile, or SE_stream_prepare_sql after SE_stream_execute is called. SE_stream_fetch can access each retrieved row sequentially.

SE_stream_fetch populates the data and indicator pointers for all columns that were bound with SE_stream_bind_output_column. The application can retrieve individual values with the SE_stream_get_* functions for any columns that were not bound.

After fetching all rows of a given query, the next call to SE_stream_fetch returns the code SE_FINISHED. SE_stream_fetch will return a -22 code when used with SE_stream_delete_row deleting multiple rows.

Returns

SE_SUCCESS
SE_FINISHED

SE_CONNECTION_IN_USE

SE_CONNECTION_LOCKED

SE_DB_IO_ERROR

SE_FUNCTION_SEQUENCE_ERROR

SE_INVALID_PARAM_VALUE

SE_INVALID_SQL

SE_INVALID_STREAM

SE_LOG_IO_ERROR

SE_LOG_NOTOPEN

SE_NET_FAILURE

SE_NOT_A_SELECT_STATEMENT

SE_OUT_OF_CLMEM

SE_OUT_OF_SVMEM

SE_SDE_NOT_STARTED