16.20 - HELP TABLE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)

HELP TABLE displays the properties of the system generated TD_TIMEBUCKET, TD_TIMECODE, and TD_SEQNO columns for PTI Tables, in addition to the other columns of the table. HELP TABLE also includes the Time Series Column Type attribute, which can have the values listed in the table below.

Time Series Column Time Series Column Type
TD_TIMEBUCKET TB
TD_TIMECODE TC
TD_SEQNO TN

Example: HELP PTI Table

Below is the table definition for the example:
CREATE SET TABLE tstab1, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO
( TD_TIMEBUCKET BIGINT NOT NULL GENERATED SYSTEM TIMECOLUMN,
  TD_TIMECODE TIMESTAMP(6) NOT NULL GENERATED TIMECOLUMN,
  TD_SEQNO INT NOT NULL GENERATED TIMECOLUMN,
  c1 INTEGER, c2 INTEGER, c3 VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY TIME INDEX (TIMESTAMP(6), DATE '2015-05-02', HOURS(1 ) , COLUMNS( c1 ,c2 ) ,SEQUENCED) ;
This statement displays the help information for tstab1:
HELP TABLE tstab1;
Following is the HELP TABLE output for each of the columns, which includes the Time Series Column Type for each of the system generated columns:
  • TB for the TD_TIMEBUCKET column
  • TC for the TD_TIMECODE column
  • TN for the TD_SEQNO column

The C1, C2, and C3 columns do not include a Time Series Column Type attribute.

Column Name TD_TIMEBUCKET
Type I8
Comment ?
Nullable N
Format -(19)9
Title ?
Max Length 8
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
UpperCase N
Table/View? T
Default value ?
Char Type ?
IdCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name TD_TIMEBUCKET
Column SQL Name TD_TIMEBUCKET
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Time Series Column Type TB
Column Name TD_TIMECODE
Type TS
Comment ?
Nullable N
Format YYYY-MM-DDBHH:MI:SS.S(6)
Title ?
Max Length 26
Decimal Total Digits ?
Decimal Fractional Digits 6
Range Low ?
Range High ?
UpperCase N
Table/View? T
Default value ?
Char Type ?
IdCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name TD_TIMECODE
Column SQL Name TD_TIMECODE
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Time Series Column Type TC
Column Name TD_SEQNO
Type I8 Comment ?
Nullable N
Format -(19)9
Title ?
Max Length 8
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
UpperCase N
Table/View? T
Default value ?
Char Type ?
IdCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name TD_SEQNO
Column SQL Name TD_SEQNO
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Time Series Column Type TN
Column Name c1
Type I
Comment ?
Nullable Y
Format -(10)9
Title ?
Max Length 4
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
UpperCase N
Table/View? T
Default value ?
Char Type ?
IdCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name c1
Column SQL Name c1
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Column Name c2
Type I
Comment ?
Nullable Y
Format -(10)9
Title ?
Max Length 4
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
UpperCase N
Table/View? T
Default value ?
Char Type ?
IdCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name c2
Column SQL Name c2
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Column Name c3
Type CV
Comment ?
Nullable Y
Format X(10)
Title ?
Max Length 10
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
UpperCase N
Table/View? T
Default value ?
Char Type 1
IdCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name c3
Column SQL Name c3
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?