Home Page for the TeradataForum
 
https:

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?


Regards,

Shubhangi



     
  <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