Teradata Database Message 9536 - 9536 - Analytics Database - Teradata Vantage

Message

RANGE_N defines more than %VSTR result values.

Explanation

A RANGE_N function with INTEGER data type must not define more than 2147483647 result values (including all the ranges, and the NO RANGE, UNKNOWN, and NO RANGE OR UNKNOWN options if specified). In this case, the value for VSTR is "2147483647". A RANGE_N function with BIGINT data type must not define more than 9223372036854775807 result values (including all the ranges, and the NO RANGE, UNKNOWN, and NO RANGE OR UNKNOWN options if specified). In this case, the value for VSTR is "9223372036854775807".

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Examine the RANGE_N function invocation and verify that it is correct. Modify the arguments to the RANGE_N such that maximum result value does not exceed the limit.