Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 05 Dec 2012 @ 10:57:34 GMT


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


Subj:   Re: SET table with UPI
 
From:   Frydryszak, Marek

  1. As you have defined a UPI, there won't be any duplicate check, with rows coming against rows exist."  


It isn't the full true.

Insert-Select to set UPI table removes silently duplicates without unique index violation.



     
  <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: 28 Jun 2020