Previous Topic: Get Input Parameter DescriptionsNext Topic: Execute the Statement


Bind Input Parameters

The application uses SQLBindParameter to specify the type of each parameter and the buffer that contains its value when the statement is executed. An application would usually specify the same type attributes that were returned by SQLDescriberParam. If a parameter's attributes are changed in a way that is incompatible with the previous definition and the server is r12.0, the driver must PREPARE the statement again before executing it. This is transparent to the application, but may cause an additional converse with the server. The driver does not need to PREPARE the statement again if the server is r14.0 or later.

If the application calls the ODBC SQLDescribeParam function subsequent to SQLBindParameter, then the results returned reflect the column definitions as they exist in the CA IDMS catalog, rather than that of a prior SQLBindParameter call.