TableTypeFilter IBM data server driver configuration keyword

Defines a default list of table types that are returned when querying table information.

Equivalent CLI keyword

Equivalent IBM® data server provider for .NET connection string keyword

N/A

IBM data server driver configuration file (db2dsdriver.cfg) syntax

<parameter name="TableTypeFilter" value=" 'ACCEL-ONLY
TABLE' | ,'ALIAS' | ,'AUXILIARY
TABLE' | ,'GLOBAL TEMPORARY TABLE' | ,'HIERARCHY
TABLE' | ,'INOPERATIVE VIEW' | ,'MATERIALIZED
QUERY TABLE' | ,'NICKNAME'
| ,'SYNONYM' | ,'SYSTEM
TABLE' | ,'TABLE' |
,'TYPED TABLE' | ,'TYPED
VIEW' | ,'VIEW' "/>

Default setting:

No default list of table types is defined.

Usage notes:

If database contains a large number of tables, the TableTypeFilter keyword can be specified to reduce the time it takes for the application to query table information, and reduce the number of tables that are listed by the application.

Any number of the values can be specified. Each type must be delimited with single quotation marks, which are separated by commas, and in uppercase. For example:

    TableTypeFilter='TABLE','VIEW'

The TableTypeFilter keyword can be used with the ZOSDBNameFilter and SchemaFilter keywords to further limit the number of tables for which information is returned.

The TableTypeFilter keyword is used to provide a default for the function that retrieves the list of tables, views, aliases, and synonyms in the database. If the application does not specify a table type on the function call, and this keyword is not used, information about all table types is returned. If the application does supply a value for the TableType argument on the function call, then that argument value overrides the TableTypeFilter keyword value.

If TableTypeFilter includes any value other than TABLE, then the ZOSDBNameFilter keyword setting cannot be used to restrict information to a particular Db2 for z/OS database.

The Db2 for z/OS Version 10 server and Version 11 with PTF PI19449 can provide the extended table information about the IBM Db2® Analytics Accelerator tables. When the ExtendedTableInfo keyword is set to True, you can specify the ACCEL-ONLY TABLE value for the TableTypeFilter keyword.