Suppressing row format metadata

You can improve the performance of repeatedly executed queries with the Adaptive Server ODBC driver by instructing Adaptive Server to suppress row format metadata (TDS_ROWFMT or TDS_ROWFMT2) for queries that are re-executed in a session. Adaptive Server 15.7 ESD#1 and later supports row format metadata suppression.

To suppress row format metadata, use the SuppressRowFormat connection string property.

The valid SuppressRowFormat connection string property values are:

• 0 – row format metadata is not suppressed.

• 1– the default value; Adaptive Server will not send row format metadata where possible.

This ODBC connection string causes row format metadata to be suppressed:

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