15.00 - 5561 The primary index values are mismatched in the UPSERT statement. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5561 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.

Remedy:

Correct the UPSERT statement and resubmit.