Error 3706 while creating TRANSACTIONTIME Temporal Table

Database
Enthusiast

Error 3706 while creating TRANSACTIONTIME Temporal Table

I am facing some error while creating a TRANSACTIONTIME Temporal Table. I am not sure if that requires some settings at the back end by the DBAs.

CREATE MULTISET TABLE TD_CAPG_FS.CUST_SUBSCRIPTION1 ,FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      CUST_ID INTEGER,

      SUBSCRIBE_TYPE CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      SUBSCRIB_AMT DECIMAL(19,7),

      SUBSCRIB_VALIDITY  PERIOD(TIMESTAMP(6) WITH TIME ZONE ) NOT NULL AS TRANSACTIONTIME)

PRIMARY INDEX ( CUST_ID );

Error I am getting:

CREATE TABLE Failed 3706: Syntax error: Temporal Operations are not supported on this system.

Would appreciate any help.

Thanks

Manik

8 REPLIES
Senior Supporter

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

I guess you run 13.1 - otherwise it will not supported from the release.

On 13.1 it need to be activated and maybe charged and it is not a standard DBS controll field where you can switch it on. You need to talk to your TD people.

Enthusiast

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

Thanks Ulrich,

I'll see into that.

Enthusiast

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

Just to confirm if I understand this.

It will run on 13.10 ver onwards without any issues but on 13.0 it needs to be activated right ?

Senior Supporter

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

no it will only work from 13.1 onwards but need activated there as well

Senior Supporter

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

And this is from 13.1 release summary document:


You may not use the Temporal Table Support capability without


a separate license. The license is included in the Teradata


Enterprise Warehouse Edition, and may be purchased separately


for the Teradata Base Edition. Contact your Teradata sales


representative to purchase and enable Temporal Table Support.


The fact that Temporal Table Support material may be included


in product CDs or downloads, or is described in documentation


you receive does not authorize you to use it without having the


appropriate license.

Enthusiast

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

I believe that temporal support is enabled in the Teradata Express Edition release for 13.10.  Can anyone confirm that?

Teradata Employee

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

the thing is if your database is getting the time from the system, then you also get this error.

check your dbsControlParamater 57 under general, it must be 2 if I'm correct.

Teradata Employee

Re: Error 3706 while creating TRANSACTIONTIME Temporal Table

Got the same error.

The temporal "feature" must be activated on TD by the TD DBA, probably.