Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: 05565 Error: Update in the update statement is a Complex Update
From:   John_Wight

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!!


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023