15.00 - 3538 A MultiLoad UPDATE Statement is Invalid. - 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)

3538 A MultiLoad UPDATE Statement is Invalid.

Explanation:

The user has provided an UPDATE statement in a MultiLoad Complex Import Task that does not fully specify a primary index value, does not fully specify the values of all the partitioning columns, or modifies the primary index or partitioning columns.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

Correct the error and resubmit the request. The WHERE condition, including any taken from a view definition, must allow for primary index access (and, if partitioned, partition access) with possible ANDed residual conditions. The list of updated fields must not include any column in the primary index or partitioning expression, and only one table may be referenced.