DB2 10.5 for Linux, UNIX, and Windows

TableType CLI/ODBC configuration keyword

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

db2cli.ini keyword syntax:

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 for IBM z/OS (IDAA) tables. When the ExtendedTableInfo keyword is set to True, you can specify the ACCEL-ONLY TABLE value for the TableType keyword.