Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 15:03:55 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: UPSERT ERROR (5565)
From:   Narayan Murthy

I think it is not a bug. For the reason Error 5565(complex update) is returned in the following cases:

- When you try to update a primary index

- Update that have a subquery

- Update's from another table

Basically if you see an UPSERT is targetted at a Single AMP operation and anything apart from that which would require more than one AMP would be termed as a Complex update - as are the cases above.

In your case too, I guess since you have a secondary index defined on the primary index any update or insert would require an update or insert into the secondary index subtable - more than ONE amp come into picture.

Thereby removing the USI boils down the equation to a SINGLE AMP operation and thus the query goes through.

I think logically this should be the reason, perhaps someone can correct me if it is not so.


  <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