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:
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:HELP TABLE tstab1;
- 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 ?