Archives of the TeradataForum
Message Posted: Fri, 15 Dec 2006 @ 13:02:07 GMT
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..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|