Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 13:02:07 GMT


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


Subj:   Re: Update Table Error - 7547: Target row updated by multiple source rows.
 
From:   ravivijay.kumar

Hi,

In case you don't have PDF for msgs here is the explanation which is crystal clear and might helps you..


7547 Target row updated by multiple source rows.

Explanation: In present system we do not support to update the target row with multiple source rows. Before implementing Merge Update the join updates were processed in two steps, Merge Delete and Merge Insert. Since, we used to delete all the rows, we end up generating the duplicate rows to insert. In that scenario, we return a different error. This type of Merge Updates (Join Updates) are not allowed.

For tables T1(a1,b1,c1), T2(a2,b2,c2), consider the Update

     update t1 from t2 set c1=c2 where a1=b2 and b2 10;

If there are more than one row satisfying this condition, we are not sure which row needs to be used for this update. In this scenario, we return this error message.

Generated By: AMP subsystem

For Whom: User

Remedy: See that source rows are unique before updating.


I Guess this might helps you..


Thanks,

Vijay kumar.R



     
  <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: 27 Dec 2016