All Forums Database
pranilrp 9 posts Joined 07/10
26 Aug 2011
creating temporal table


I am new to td 13 temporal database concept.

I tried to create temporal table by following :-




Customer_ID INTEGER,

Policy_Type CHAR(2) NOT NULL,

Policy_Details CHAR(40),





its giving syntax error like "expected check or unique between NULL and AS keyword.

database version :- teradata 13.00.0105.

dnoeth 4628 posts Joined 11/04
26 Aug 2011

The temporal stuff is a new feature in TD13.10, but you're trying it on TD13.0 :-)



kunokb 14 posts Joined 08/11
29 Sep 2011


Are there any sample project in connection with the Teradata Plug-In for eclipse? I'm also interested in the system's temporal services, so I'd like to create a simple project in eclipse to demonstrate these capabilities. I think it would be very useful (not just) for me. Thanks!

js185064 9 posts Joined 03/09
30 Sep 2011


The following are two articles explaining how to use Period data types: exploring-teradata-13s-period-data-type exploring-teradata-13s-period-functions

Once you have a good understanding of period data types you can use the different Teradata Java Wizards in the Teradata Plug-In for eclipse to  create  a sample using period data types.

A fun Wizard you can start with is the iBatis CRUD Wizard: crud-wizard



kunokb 14 posts Joined 08/11
01 Oct 2011

I have already found the first two article, but the third is really new for me - and as I ran through it, it will be very useful later. Thanks a lot! :)

Do you think that this iBatis-thing is the best for me to compare the conventional support with TD 13.10's temporal support (through simple examples like in Snodgrass's case study)?

js185064 9 posts Joined 03/09
03 Oct 2011

I am not familiar with Snodgrass's case study, but if you want to create an application with different queries you can use the iBatis SQL Map and the iBatis DAO with Web Services Wizards.



iBatis SQL Map Wizard:


iBatis DAO with Web Services Wizard:

kunokb 14 posts Joined 08/11
04 Oct 2011

Thanks again!


Snodgrass' case study from the Teradata Temporal page:

js185064 9 posts Joined 03/09
04 Oct 2011

The iBatis SQL Map Wizard from Teradata Plug-In for Eclipse

should work with the queries from the Snodgrass' case study.

You must sign in to leave a comment.