15.00 - 3535 A character string failed conversion to a numeric value. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3535 A character string failed conversion to a numeric value.

Explanation:

A character string constant in a query is in a context requiring that it represent a numeric value, and it does not.

Generated By:

OPT modules.

For Whom:

End User.

Notes:

It is preferable to use a numeric value rather than a character representation of a numeric value. This avoids the need for conversion and is more efficient.

Remedy:

Change the constant to either a numeric value or a character string that represents a numeric value.