15.00 - 3555 Only the last WITH clause can omit the BY information. - 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)

3555 Only the last WITH clause can omit the BY information.

Explanation:

Omitting the BY portion of the WITH clause implies that the WITH summary must be done on the entire base table. Since WITH clauses are assumed to appear in increasing scope, following such a WITH with a narrower-scope WITH should not be done.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

If possible, reorder the WITH clauses and resubmit the request.