0 - 4 of 4 tags for updates
Temporal Table Updates

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.

By Kishore_1, 08 May 2014 | Tagged: Temporal table updates
New to Teradata - Update a table with another records in same table

Hi Experts,

 

I am new to teradata and a lot of posts on these forms have helped me a great deal but I cannot find the answer to a problem I have. Hoping someone can help me out here.

 

I have a table with the following layout:

State | Account_ID | Member_ID | Duration | Product_To | Product_From

By mabsiddiqui, 16 Jul 2012 | Tagged: updates | 10 comments
Where do the rows go?

With row partitioning (for a PPI or column-partitioned table), the Teradata Database makes sure rows are placed in their appropriate partitions.  When the row partitioning for the table is altered, rows may need to move from one partition to another so they are in their appropriate partitions according to the altered partitioning.  The partitioning expression must be deterministic (always computes the same value for the same value of the partitioning column) to properly place and retrieve the row.

For instance if the table has RANGE_N partitioning, ALTER TABLE will move rows automatically from NO RANGE to newly-added ranges as needed.  Also, if a range is dropped, rows from that partition are moved to the NO RANGE, NO RANGE OR UNKNOWN partition or a newly-added range that covers the dropped range.

By PaulSinclair, 21 Mar 2012 | Tagged: database ppi partitioning drop alter table range_n add with delete with insert updates | 6 comments
.net 64 bit and SQL Server not performing updates

Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
When I try to do an Update to my table on Teradata - I have nothing that lets me specify the Database or Table I want to update - but I get a response saying everything completed successfully.

By Cathybritt, 23 Aug 2011 | Tagged: .net sql server updates