DB2 10.5 for Linux, UNIX, and Windows

ExtendedTableInfo CLI/ODBC configuration keyword

Specifies whether the extended table information about the DB2® for z/OS® tables are returned in a result-set of the SQLTables() function.

db2cli.ini keyword syntax:

ExtendedTableInfo = True | False

Default setting:

The default value is False.

Usage notes:

The ExtendedTableInfo keyword takes effect only when you are connecting to the DB2 for z/OS Version 10 and Version 11 server with PTF PI19449 applied.

True

A result-set that is returned by the SQLTables() function contains information about the extended table types and accelerator-related catalog information. The following list contains name of extra columns that are returned when the ExtendedTableInfo keyword is set to True.

Column 6 TEMPORAL_TABLE_TYPE (VARCHAR(11))
Column 7 IS_ACCELERATED (VARCHAR(3))
Column 8 ACCEL_ARCHIVE_STATUS (VARCHAR(1))
Column 9 IS_ARCHIVE_ENABLED (VARCHAR(3))

You can also specify all valid table types in the TableType argument of the SQLTables() function, the TableType CLI keyword, or the TableTypeFilter IBM® data server driver configuration keyword. The following list contains valid table types:

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

If you do not explicitly set the TableType or TableTypeFilter keyword, all table types are returned in the SQLTables() result-set.

False

A result-set that is returned by the SQLTables() function does not contain information about the IBM DB2 Analytics Accelerator for IBM z/OS (IDAA) tables. The SQLTables() result-set contains original five columns.

You cannot specify the ACCEL-ONLY TABLE table type in the TableType argument of the SQLTables() function, the TableType keyword, or the TableTypeFilter keyword.

If you do not specify any values for the TableType argument of the SQLTables() function, the TableType keyword, and the TableTypeFilter keyword, the SQLTables() result-set contains all supported table types, which include the IDAA tables.

If you specify the TABLE value for the TableType argument of the SQLTables() function, the TableType keyword, or the TableTypeFilter keyword, the SQLTables() result-set contains all tables including the IDAA tables.