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

Teradata Vantageā„¢ - Database Messages

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Numeric overflow in UDF/XSP/UDM involving result argument for %TVMID.%FLDID.
This error indicates that the UDF/XSP/UDM has produced a result that is out of range for the given returned data type. All FLOAT, DECIMAL, DATE (TIMESTAMP etc.) and INTERVAL types will get this error if they produce a value that is not with in the valid range of the type it is returning. For example a DECIMAL(2,1) can only return values between -99.9 and 99.9. Anything outside of that range will produce this error. In a like manner DATE and TIMESTAMP types must produce a valid timestamp. For example the month must be in the range of 1-12. The day of the month must be in the valid range for the given month and so on. For INTERVAL types the value must conform to the precision of the defined INTERVAL. For example INTERVAL YEAR(2) can only return an interval between -99 and 99 years.
Generated By
The interpretative instruction processor.
For Whom
End User.
Resubmit the request after either fixing the UDF/XSP/UDM code or changing the returned data type to accommodate the result.