Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 03 Jun 2005 @ 13:41:28 GMT

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

Subj:   Re: Source data for Multiload!!!
From:   Victor Sokovin

  Dennis, I'm glad you brought this up. I'm not sure what your second sentence means -- atomic upsert (UPDATE ... ELSE INSERT) is an SQL statement, and it was introduced in V2R4.1. So what exactly is the purpose of MERGE INTO?  

Good question. Perhaps ANSI compatibility?

Some mystery surrounds MERGE INTO.

From a mere undocumented synonym of INSERT ... SELECT


it seems to have merged into something interesting.

For some reason I have missed out on this development and am glad it was mentioned in the thread.



  <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