Suppressing Row Format Metadata

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.

Note: You can suppress row format metadata only if the connected Adaptive Server supports this feature. If the SuppressRowFormat is 1 but the connected Adaptive Server does not support the suppression of row format metadata, Adaptive Server ignores the parameter.

For example, this ODBC connection string causes row format metadata to be suppressed:

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