DB2 Version 9.7 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:: TableType = " 'TABLE' | ,'ALIAS' | ,'VIEW' | , 'INOPERATIVE VIEW' | , 'SYSTEM TABLE' | ,'SYNONYM' "
Default setting:: No default list of TABLETYPES is defined.
Usage notes:

If there is a large number of tables defined in the database, a tabletype string can be specified to reduce the time it takes for the application to query table information, and reduce the number of tables listed by the application.

Any number of the values can be specified. Each type must be delimited with single quotes, separated by commas, and in uppercase. The entire string must also be enclosed in double quotes. For example:

    TableType="'TABLE','VIEW'"

This option can be used in conjunction with DBNAME and SCHEMALIST to further limit the number of tables for which information will be returned.

TableType 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 on the function call, then that argument value will override this keyword value.

If TableType 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.