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 Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023