Teradata Database Message 5561 - 17.10 - 5561 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
The primary index values are mismatched in the UPSERT statement.
Explanation
The user specified different primary index values for the UPDATE and the INSERT parts of an UPSERT statement. The same primary index values must be used in both parts of an UPSERT statement, since the purpose of an UPSERT is to find a row or rows to update, and if no row is found to insert a corresponding row into the table.
Generated By
Parser.
For Whom
End User.
Notes
None
Remedy
Correct the UPSERT statement and resubmit.