Suppressing Parameter Format Metadata

Improve the performance of prepared statements with the ODBC driver by suppressing parameter format metadata when the prepared statements are re-executed.

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

To suppress parameter format metadata, 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.

For example, this ODBC connection string causes parameter format metadata to be suppressed in prepared statements:

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