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 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 IBM Db2 Analytics Accelerator 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.