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,
SUBSCRIBE_TYPE CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
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.
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.
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 ?
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
I believe that temporal support is enabled in the Teradata Express Edition release for 13.10. Can anyone confirm that?
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.