Return codes, See also, Querying with a prepared statement – Sun Microsystems Sun StorageTek 5800 User Manual
Page 110
Return Codes
HCERR_OK
HCERR_OOM
HCERR_BAD_REQUEST
HCERR_NULL_SESSION
HCERR_INVALID_SESSION
HCERR_ILLEGAL_ARGUMENT
See Also
Querying With a Prepared Statement
The following code is an example of querying with a prepared statement. Error handling is
omitted. Two metadata fields are used with the definitions from the schema:
"test_date" type="date"> "test_status" type="string"> hcerr_t res; time_t t; struct tm *date; hc_pstmt_t *pstmt; hc_query_result_set_t *rset; hc_string_t selects[] = { "test_status" }; // get today ’s date time(&t); date = gmtime(&t); // list all OIDs with today ’s date res = hc_pstmt_create(session, "test_date = ?", &pstmt); res = hc_pstmt_set_date(pstmt, 1, date); res = hc_pstmt_query_ez(pstmt, NULL, 0, 2000, &rset); while (1) { hc_oid oid; int finished; res = hc_qrs_next_ez(rset, &oid, NULL, &finished); if (finished) break; printf( "today’s oid: %s\n", oid); } res = hc_qrs_free(rset); Querying With a Prepared Statement Sun StorageTek 5800 System Client API Reference Manual • June 2008 110