15.00 - 5746 The partitioning expression for level %VSTR is not valid; partitioning expressions for multi-level partitioning must be RANGE_N or CASE_N functions. - 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)

5746 The partitioning expression for level %VSTR is not valid; partitioning expressions for multi-level partitioning must be RANGE_N or CASE_N functions.

Explanation:

For a CREATE TABLE or ALTER TABLE statement, if more than one parti-tioning expression is specified in the PARTITION BY clause, each such partitioning expression must consist solely of either a RANGE_N or CASE_N function. The partitioning expression at the specified level is neither solely a RANGE_N nor CASE_N function. Note that it is not required that the parti-tioning expressions be all of one form or the other (some could be RANGE_N functions and others CASE_N functions).

Generated By:

RES modules.

For Whom:

End User.

Remedy:

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the multi-level partitioned primary index rules and re-submit the request.