Teradata Database Message 3537 - 3537 - Analytics Database - Teradata Vantage

Message

A MultiLoad DELETE Statement is Invalid.

Explanation

In a MultiLoad Complex Import Task, the user provided a DELETE statement that does not fully specify a primary index value or the values of all the partitioning columns. Or, in a MultiLoad Delete Task, the user provided a DELETE statement that specified a primary index.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Correct the error and resubmit the request. In a MultiLoad Complex Import Task, 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. It must also reference no other tables or views. In a MultiLoad Delete Task, the WHERE condition, including any taken from a view definition, must not include a primary index access. It must also reference no other tables or views.