All Forums Database
LUCAS 56 posts Joined 06/09
09 Feb 2016
CREATE SYSTEM TIME TABLE in error

Hi all,
i try to create a SYSTEM_TIME table (ANSI) from a session in ANSI mode and in TERADATA mode as well (database V14.10, SQLA 14.10)
in each case i get an error (3706 Syntax error: expected something between the 'AS' keyword and the 'ROW' keyword).
CREATE MULTISET TABLE mydatabase.TEMP_SYS_TIME_ANSI , no log
(
DT_TST DATE FORMAT 'yyyy-mm-dd' NOT NULL,
ID_TST SMALLINT NOT NULL,
LB_TST varchar(32) ,
SYS_START TIMESTAMP(6) WITH TIME ZONE NOT NULL
                                                            GENERATED ALWAYS AS ROW START,  -- according to doc B035-1186-015K ANSI TEMPORAL TABLE SUPPORT
SYS_END TIMESTAMP(6) WITH TIME ZONE NOT NULL
                                                            GENERATED ALWAYS AS ROW END,
PERIOD FOR SYSTEM_TIME(SYS_START, SYS_END)
)
PRIMARY INDEX ( ID_TST ) WITH SYSTEM VERSIONING;
did i miss a syntax form ?
Thanks for help,
Pierre

dnoeth 4628 posts Joined 11/04
09 Feb 2016

Hi Pierre,
ANSI Temporall was introduced in TD15 and you're running TD14.10 :-)

Dieter

LUCAS 56 posts Joined 06/09
09 Feb 2016

Hi Dieter,
indeed ... waiting for TD15.10. 
btw, is that "create system time table" accepted in an ANSI mode session only ?
Thanks,
Pierre

dnoeth 4628 posts Joined 11/04
09 Feb 2016

Hi Pierre,
no, works in both ANSI and BTET mode.

Dieter

You must sign in to leave a comment.