An ODBC application can prepare a query that contains dynamic parameters. Each parameter in a SQL statement must be associated, or bound, to a variable in the application before the statement is executed. When the application binds a variable to a parameter, it describes that variable and that parameter to the driver. Therefore, the application must supply the following information:
The data type of the variable that the application maps to the dynamic parameter
The SQL data type of the dynamic parameter (the data type that the database system assigned to the parameter marker)
The two data types are identified separately using the SQLBindParameter function. You can also use descriptor APIs as described in the Descriptor section of the ODBC specification (version 3.0 and higher).
The driver relies on the binding of parameters to know how to send information to the database system in its native format. If an application furnishes incorrect parameter binding information to the ODBC driver, the results will be unpredictable. For example, the statement might not be executed correctly.
To ensure interoperability, your Progress DataDirect forODBC driver uses only the parameter binding information that is provided by the application.
The data type of the variable that the application maps to the dynamic parameter