Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 21:27:48 GMT

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

Subj:   Re: ML Error 2801: Duplicate unique prime key
From:   Pararha, Shubhangi

Yep true....

I thought he is loading from table to table.....

I was expecting, if the duplication is within the source table he would get the error:

"7547 Target row updated by multiple source rows."

But if it's in mload...using insert and update statements in the mload with the option 'do insert for missing update' should work?



  <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