HELP TABLE with PTI Table Example | Teradata Vantage - 17.00 - Example: HELP PTI Table - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K
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 ?