TableType CLI/ODBC and IBM data server driver configuration keyword

Defines a default list of TABLETYPES returned when querying table information.

db2cli.ini keyword syntax:: TableType = " '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' "
IBM data server driver configuration file (db2dsdriver.cfg) syntax:: <parameter name="TableType" 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' "/>

Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.

Default setting:

No default list of table types is defined.

Usage notes:

If database contains a large number of tables, the TableType 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 mark, which is separated by commas, and in uppercase. The entire string must also be enclosed in double quotation marks. For example:

    TableType="'TABLE','VIEW'"

The TableType keyword can be used with the DBNAME and SCHEMALIST keywords to further limit the number of tables for which information is returned.

The TableType keyword is used to provide a default for the CLI 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 TableType keyword value.

If TableType keyword includes any value other than TABLE, then the DBName 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 TableType keyword.