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.

Solution:

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: April 21, 2017