Teradata Database Message 5560 - 5560 - Analytics Database - Teradata Vantage

Message

Table names are mismatched in the UPSERT statement.

Explanation

The user specified two different tables in the UPDATE and INSERT parts of an UPSERT statement. The same table must be referenced 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.