Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2010 @ 19:11:41 GMT

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

I know the TD manuals are not always the 'easiest' to use, but try the Error Message manual - it's usually pretty good for finding out what the error code means - in this case:

5565 The UPDATE specified in the UPSERT statement is a complex update.

Explanation: The user specified the UPDATE in the UPSERT statement as a complex update. Examples of complex update are UPDATEs that change the primary index value or the value of a partitioning column, UPDATEs that have subquery, and UPDATEs from another table. Only simple prime-key UPDATEs are allowed in UPSERTs.

Generated By: Parser.

For Whom: End User.

Remedy: Correct the UPSERT statement and resubmit

hope this helps!!

JK

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