Teradata Database Message 9462 - 9462 - Analytics Database - Teradata Vantage

Message

Data type of range boundary is incompatible with the test value type.

Explanation

For a RANGE_N function or an ALTER TABLE, the data type of a range boundary in an EACH clause must be compatible for casting to the data type of the test value, and not result in a precision loss. For example, casting of a REAL number with digits to the right of of the decimal place, to an integer, would result in truncation of the fractional digits and loss in precision.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the RANGE_N function rules and resubmit the request.