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

Hi,

I am new to td 13 temporal database concept.

I tried to create temporal table by following :-

 

CREATE MULTISET TABLE Policy(

Policy_ID INTEGER,

Customer_ID INTEGER,

Policy_Type CHAR(2) NOT NULL,

Policy_Details CHAR(40),

Validity PERIOD(DATE) NOT NULL AS VALIDTIME

)

PRIMARY INDEX(Policy_ID);

 

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 :-)

Dieter

Dieter

kunokb 14 posts Joined 08/11
29 Sep 2011

Hi!

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:

http://developer.teradata.com/database/articles/ exploring-teradata-13s-period-data-type

http://developer.teradata.com/database/articles/ 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:

http://developer.teradata.com/tools/articles/ibatis- 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:

http://developer.teradata.com/tools/articles/create-an-ibatis-sql-map-with-teradata-plug-in-for-eclipse

 

iBatis DAO with Web Services Wizard:

http://developer.teradata.com/tools/articles/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:

http://www.teradata.com/product.aspx?id=15654
http://www.teradata.com/white-papers/A-Case-Study-of-Temporal-Data-eb6237/

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.