CREATE SYSTEM TIME TABLE in error

Database
Enthusiast

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

3 REPLIES
Junior Contributor

Re: CREATE SYSTEM TIME TABLE in error

Hi Pierre,

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

Enthusiast

Re: CREATE SYSTEM TIME TABLE in error

Hi Dieter,

indeed ... waiting for TD15.10. 

btw, is that "create system time table" accepted in an ANSI mode session only ?

Thanks,

Pierre

Junior Contributor

Re: CREATE SYSTEM TIME TABLE in error

Hi Pierre,

no, works in both ANSI and BTET mode.