ibmcognos.qualifier_list

This parameter is used to disambiguate metadata when dynamic queries are executed. It assigns a list of one or more qualifiers to data sources that are defined in IBM® Cognos® Analytics.

The following examples show the syntax to use when specifying the ibmcognos.qualifier_list parameter, and the values that can be assigned for it:

• ibmcognos.qualifier_list=CATALOG1.SCHEMA1, CATALOG2.SCHEMA2
• ibmcognos.qualifier_list=SCHEMA1, SCHEMA2
• ibmcognos.qualifier_list=CATALOG1.SCHEMA1, SCHEMA2
• ibmcognos.qualifier_list=CATALOG1, CATALOG2

A period in the qualifier is used to separate the catalog and schema components. If no period is present and the database supports schemas, the value is treated as a schema. Otherwise, the value is treated as a catalog, if the database supports catalogs.

The query service searches the list in the order specified, and uses the column metadata that it finds for the first qualifier that matches. If no match is found, an ambiguous metadata error is thrown.

The administrator should confirm that the list of qualifiers that are provided for this parameter is identical in order and content to any search list that the user’s database session might have defined. The qualifier list is applied only when the session attempts to disambiguate metadata that is returned by a JDBC driver. Qualified names in dynamic SQL statements reflect the values assigned to catalog or schema properties that the package data source used during query planning.