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.
Still have questions? We can help. Submit a case to Technical Support.