Home Page for the TeradataForum

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