The 16.20 database has a new table called a Primary Time Index (PTI) table. For more information, refer to Detailed Feature External Specification for Time Series. The TD ODBC Driver does not add any additional functionalities to handle this new table type, but the ODBC API function SQLStatistics now returns two additional columns described in the following table:
| Column Name | Column Number | Data Type | Comment |
|---|---|---|---|
| TD_TIMEZERO | 14 | varchar |
The time zero point associated with the table. For example, “2015-10-22”. Null if the table is not a PTI table. |
| TD_TIMEBUCKET | 15 | varchar |
The length of a time bucket. For example, “HOURS(1)”. Null if the table is not a PTI table. |