All Forums Database
mjasrotia 66 posts Joined 08/11
08 Feb 2012
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

ulrich 816 posts Joined 09/09
08 Feb 2012

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.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

mjasrotia 66 posts Joined 08/11
08 Feb 2012

Thanks Ulrich,

I'll see into that.

 

mjasrotia 66 posts Joined 08/11
08 Feb 2012

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 ?

ulrich 816 posts Joined 09/09
08 Feb 2012

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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

ulrich 816 posts Joined 09/09
08 Feb 2012

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.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Jim Chapman 449 posts Joined 09/04
08 Feb 2012

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

 

senem.deger 1 post Joined 04/10
12 Sep 2012

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.

regards,

SeNeM

Dany3R9 18 posts Joined 03/14
21 Jul 2014

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

You must sign in to leave a comment.