Teradata Database Message 9536 - 17.10 - 9536 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.