Teradata Database Message 7576 - 17.10 - 7576 - 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
Numeric overflow in UDF/XSP/UDM involving result argument for %TVMID.%FLDID.
Explanation
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.
Notes
None
Remedy
Resubmit the request after either fixing the UDF/XSP/UDM code or changing the returned data type to accommodate the result.