open_result_set

The open_result_set v4 API method opens a result set for a table value.

Declaration

short open_result_set(
a_v4_extfn_proc_context *cntxt,
a_v4_extfn_table *table,
a_v4_extfn_table_context **result_set
)

Usage

open_result_set opens a result set for a table value. A UDF can open a result set to read rows from an input parameter of type DT_EXTFN_TABLE. The server (or another UDF) can open a result set to read rows from the UDF.

Parameters

Parameter Description
cntxt The procedure context object
table The table object on which to open a result set
result_set An output parameter that is set to be an opened result set

Returns

1 if successful, 0 otherwise.

Example 1

See the fetch_block and fetch_into v4 API method descriptions for examples of the use of open_result_set.

Parent topic: External Procedure Context (a_v4_extfn_proc_context)