SQLStatistics - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Starting with Advanced SQL Engine 16.20, there is a new table called a Primary Time Index (PTI) table. For more information, refer to Detailed Feature External Specification for Time Series. ODBC Driver for Teradata 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, “2019-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.