![]() |
Using Teradata Database 14.0.5 in a Virtual Machine and testing the following steps specified in a reference document, "Temporal Table Support" (Release 14.0) page 36 "Converting Period or DateTime Columns to a Transaction-Time Column", an error was encountered in an ALTER TABLE step to DROP the old PERIOD column: (Is there a missing step that will preven
23 Mar 2016
| 1 comment
,
|
![]() |
Existing data in table test : (Temporal table) id name valid_dt Incoming Table : (Temporal) id name valid_dt After Merge update , test table should have
17 Jun 2014
| 2 comments
,
|
![]() |
I have a temporal table,"Policy_Dtls" with columns: CustID,PolicyID,PolicyType,ServiceReq_Num,Policy_Mod_TT . Policy_Mod_TT is TransactionTime column. Initially Customer A is offered a policy '123X' ,Policytype:General through Service Request No# 123985.
08 May 2014
,
|
![]() |
I am getting the following error while using the following query: CURRENT VALIDTIME SELECT * FROM Policy; *** Failure 9330 ValidTime qualifier requires at least one table with ValidTime. Statement# 1, Info =0 The table Policy is defined as follows: CREATE TABLE Policy(
17 Apr 2014
| 4 comments
,
|