Suppressing Parameter Format Metadata to Improve Prepared Statement Performance

Suppress parameter format metadata when the prepared statements are reexecuted to improve the performance of prepared statements with the ODBC driver.

Adaptive Server 15.7 ESD#1 and later supports parameter format metadata suppression.

Set the DynamicPrepare connection property to 1, and then use the SuppressParamFormat connection string property.

The valid SuppressParamFormat connection string property values are:

0 – parameter format metadata is not suppressed in prepared statements.
1– the default value; parameter format metadata is suppressed where possible.

Note: You can suppress parameter format metadata in prepared statements only if the connected Adaptive Server supports this feature. If the DynamicPrepare and SuppressParamFormat parameters are both set to 1 but the connected Adaptive Server does not support the suppression of parameter format metadata, Adaptive Server ignores the parameter settings.

Example

This ODBC connection string suppresses parameter format metadata in prepared statements:

DSN=sampledsn;UID=user;PWD=password;;DynamicPrepare=1;SuppressParamFormat=1;