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,
indeed ... waiting for TD15.10.
btw, is that "create system time table" accepted in an ANSI mode session only ?