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 ?