Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 11:28:36 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: MERGE options
From:   DWellman


I think you're correct, the MERGE (and the UPSERT suggested elsewhere) will only perform one operation for each source row - an update or an insert.

Prior to TD 13.10 i think that you have to have two operations, one an UPDATE and the other an INSERT.

On TD 13.10 this requirement could be met by using the TransactionTime Temporal feature, it's exactly what that feature is built for. With that being used your application could simply contain an UPDATE statement and the DBMS will do the Update/Insert for you. There is more to Temporal support than just described here, but it could be very useful for you.



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023