CAST Function Fails with SQL0802 Error

 

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