Teradata Database Message 2621 - 17.10 - 2621 - 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
Bad character in format or data of %TVMID.%FLDID.
Explanation
This error indicates that the user has submitted a numeric-to-character conversion with an illegal format, or that, in a character-to-numeric conversion, the data or the format contains a bad character.
Generated By
The interpretative instruction processor.
For Whom
End User.
Notes
This error occurs for the same reason as message 2620, above. However, in this case more information exists about the calculation that produced the error. The TvmId and FldId can be from the source or target row.
Remedy
Verify the format used. If it is legal, then an illegal character is present in the data being converted from character to numeric.