DisableAliasesInMetadata IBM data server driver configuration keyword

Controls whether the CLI schema APIs report aliases in the metadata results.

Equivalent CLI keyword
ReturnAliases
Equivalent IBM® Data Server Provider for .NET connection string keyword
N/A
db2dsdriver.cfg configuration syntax
<parameter name="DisableAliasesInMetadata" value="0 | 1"/>
Default setting:
There is no default setting
Usage notes:

This keyword disables the consideration of aliases (or synonyms) when qualifying rows for metadata procedures. Not considering aliases can provide significant performance benefits by avoided costly joins with the base tables to determine the addition tables that qualify for a given query.

  • 0 : Aliases will be considered when qualifying rows for metadata procedures.
  • 1 : Aliases will not be considered when qualifying rows for metadata procedures (better performance.)

The following CLI APIs are affected by this keyword :

  • SQLColumns()
  • SQLColumnPrivileges()
  • SQLTables()
  • SQLTablePrivileges()
  • SQLStatistics()
  • SQLSpecialColumns()
  • SQLForeignKeys()
  • SQLPrimaryKeys()