Sun Microsystems 5800 manual Hcpstmtqueryez

Synchronous C API Functions

hc_pstmt_query_ez

Retrieves OIDs and optionally name-value records matching a prepared statement.

Synopsis

hcerr_t hc_pstmt_query_ez(*pstmt,hc_string_t selects[],

int n_selects,

int results_per_fetch,

hc_query_result_set_t **rsetp);

Description

This function retrieves OIDs and optionally name-value records matching a prepared statement. “hc_qrs_next_ez” on page 96 is used to access the results in the result set. If the selects list is NULL, only OIDs are retrieved. If selects is not NULL, name-value records are also retrieved and should each be freed using “hc_nvr_free” on page 66. In both cases the result set should be freed using “hc_qrs_free” on page 99.

Note – When a query is incorrect and elicits an error from the server, the error is often reported after “hc_qrs_free” on page 99 and not from “hc_pstmt_query_ez” on page 109. Your application should be prepared to receive and report an error from either place.

Parameters

pstmt

IN: Prepared statement generated by “hc_pstmt_create” on page 100.

selects

IN: Points to an array of “hc_string_t” on page 46, each of which is the name of a field to retrieve from the metadata (select clause). Set to NULL to only retrieve OIDs matching the query.

n_selects

IN: The number of items in the select clause.

results_per_fetch

IN: The number of results per internal fetch.

rsetp

OUT: Updated to point to the new result set. See “hc_query_result_set_t” on page 49.

Chapter 3 • Sun StorageTek 5800 System C Client API 109