15.00 - 5742 The UPDATE part of the UPSERT does not fully specify values for the partitioning columns. - 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)

5742 The UPDATE part of the UPSERT does not fully specify values for the partitioning columns.

Explanation:

The UPDATE part of the UPSERT statement must fully specify values for all the partitioning columns by specifying an equality constraint on each of the partitioning columns to an expression having the same data type and not containing column references.

Generated By:

Parser.

For Whom:

End User. DR62813-bessc

Remedy:

Correct the UPSERT statement and resubmit.