Teradata Database Message 5968 - 5968 - Analytics Database - Teradata Vantage

Message

Atomic UPSERTS are not allowed in Multiload.

Explanation

Atomic UPSERTS are not allowed in Multiload.

Generated By

Syntaxer

For Whom

End User.

Notes

None

Remedy

Rewrite UPSERT with Update and Insert separately with the following syntax. DO INSERT FOR MISSING UPDATE ROWS; UPDATE ... WHERE PK=...; INSERT ...;