Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Fri, 03 Jun 2005 @ 12:58:02 GMT





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




Subj:   Re: Source data for Multiload!!!
 
From:   Geoffrey Rommel



  Insert/Select has a cousin called Merge/Into which was implemented in v2r 5.0. Anyway MERGE/INTO is the UPSERT command in SQL.  


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?





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008