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: January 29, 2021