4. Accessing a DBMS Using SQL : Queries, Parameters, and Query Data Correlation : Query Data Correlation
 
Share this page                  
Query Data Correlation
When an application calls IIapi_setDescriptor() to send information to the DBMS Server about parameter formats, it should make sure that the sd_descriptor parameter contains the appropriate column type and data type for each query parameter of an SQL statement.
The following table provides query parameters and their corresponding ds_columnType and ds_dataType values in the API_DESCRIPTOR structure:
Query Parameters
Descriptor Column Type
Data Type
Cursor name
IIAPI_COL_SVCPARM
IIAPI_CHA_TYPE
Cursor ID
IIAPI_COL_SVCPARM
IIAPI_APIHNDL_TYPE
Procedure ID
IIAPI_COL_SVCPARM
IIAPI_HNDL_TYPE
Procedure name
IIAPI_COL_SVCPARM
IIAPI_CHA_TYPE
Procedure owner
IIAPI_COL_SVCPARM
IIAPI_CHA_TYPE
Procedure parameters
IIAPI_COL_PROCPARM
or IIAPI_COL_
PROCBYREFPARM
IIAPI_COL_PROCINPARM
IIAPI_COL_PROCOUTPARM
IIAPI_COL_PROCINOUTPARM
Any of the Ingres data types in Ingres Data Types the “Data Types” appendix
Parameter values
IIAPI_COL_QPARM
Any of the Ingres data types in Ingres Data Types the “Data Types” appendix
Repeat query ID
IIAPI_COL_SVCPARM
IIAPI_COL_SVCPARM
IIAPI_COL_SVCPARM
IIAPI_INT_TYPE
IIAPI_INT_TYPE
IIAPI_CHA_TYPE
Repeat query handle
IIAPI_COL_SVCPARM
IIAPI_APIHNDL_TYPE
Repeat query parameters
IIAPI_COL_QPARM
Any of the Ingres data types in Ingres Data Types the “Data Types” appendix
Dynamic parameter values
IIAPI_COL_QPARM
Any of the Ingres data types in Ingres Data Types the “Data Types” appendix