Teradata Database Message 5561 - 5561 - Analytics Database - Teradata Vantage

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.