Problem Statement:

Query with CAST function & join condition fails with SQL0802 'Data conversion or data mapping error', error type 6 and SQL0420 Character in CAST argument not valid.


Remove CAST of CHAR field to numeric and change join condition to convert (i.e., CAST) the numeric field to a character value.


Ref#: 1479983





Still have questions? We can help. Submit a case to technical support

Last Modified On:
You don't have the appropriate permissions.
No, open a new Support Case