ExtendedTableInfo IBM data server driver 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 or a DataTable object of the GetSchema method.
Equivalent CLI keyword
ExtendedTableInfo
Equivalent IBM® data server provider for .NET connection string keyword
N/A
IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="ExtendedTableInfo" value="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
If your application is connecting to a server with the IBM Data Server Provider for .NET, the GetSchema method returns a DataTable object that contains DataColumn objects with information about the extended table types and accelerator-related catalog information. The following list contains name of extra DataColumn objects that are returned when the ExtendedTableInfo keyword is set to True.
  • TEMPORAL_TABLE_TYPE (VARCHAR(11))
  • IS_ACCELERATED (VARCHAR(3))
  • ACCEL_ARCHIVE_STATUS (VARCHAR(1))
  • IS_ARCHIVE_ENABLED (VARCHAR(3))
If your application is connecting to a server with the CLI driver, the SQLTables() function call returns a result-set that contains columns with 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 restrictionValues argument of the GetSchema(String, String[]) method, 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 a result-set of the SQLTables() function call or a DataTable object of the GetSchema method.
False

A result-set that is returned by the SQLTables() function or a DataTable object that is returned by the GetSchema method does not contain information about the IBM Db2 Analytics Accelerator tables.

You cannot specify the ACCEL-ONLY TABLE table type in the TableType argument of the SQLTables() function, the restrictionValues argument of the GetSchema(String, String[]) method, 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 IBM Db2 Analytics Accelerator tables.