Structure used to build and execute a query, and to iterate through the results.
|
Data Fields |
|
dba_db | db |
| | Database to operate on.
|
|
SQLHSTMT | stm |
| | ODBC statement to use for the query.
|
|
dba_querybuf | query |
| | Dynamically generated SQL query.
|
|
dba_querybuf | where |
| | WHERE subquery.
|
|
unsigned int | wanted |
| | What values are wanted from the query.
|
|
unsigned int | modifiers |
| | Modifier flags to enable special query behaviours.
|
|
unsigned int | select_wanted |
| | What is needed from the SELECT part of the query.
|
|
unsigned int | from_wanted |
| | What is needed from the FROM part of the query.
|
|
unsigned int | input_seq |
| | Sequence number to use to bind ODBC input parameters.
|
|
unsigned int | output_seq |
| | Sequence number to use to bind ODBC output parameters.
|
|
int | accept_from_ana_context |
| | True if we also accept results from the anagraphical context.
|
|
int | count |
| | Number of results still to be fetched.
|
|
|
SQL_TIMESTAMP_STRUCT | sel_dtmin |
| | Selection parameters (input) for the query.
|
|
SQL_TIMESTAMP_STRUCT | sel_dtmax |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_latmin |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_latmax |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_lonmin |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_lonmax |
| | Selection parameters (input) for the query.
|
|
char | sel_ident [64] |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_ltype1 |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_l1 |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_ltype2 |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_l2 |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_pind |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_p1 |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_p2 |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_b |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_rep_cod |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_priority |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_priomin |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_priomax |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_ana_id |
| | Selection parameters (input) for the query.
|
|
DBALLE_SQL_C_SINT_TYPE | sel_context_id |
| | Selection parameters (input) for the query.
|
|
|
DBALLE_SQL_C_SINT_TYPE | out_lat |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_lon |
| | Query results.
|
|
char | out_ident [64] |
| | Query results.
|
|
SQLLEN | out_ident_ind |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_ltype1 |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_l1 |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_ltype2 |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_l2 |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_pind |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_p1 |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_p2 |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_idvar |
| | Query results.
|
|
SQL_TIMESTAMP_STRUCT | out_datetime |
| | Query results.
|
|
char | out_value [255] |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_rep_cod |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_ana_id |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_context_id |
| | Query results.
|
|
DBALLE_SQL_C_SINT_TYPE | out_priority |
| | Query results.
|
