Error
SQLCODE -302
Host variable data type mismatch
Explanation
The host variable data type is incompatible with the column.
Solution
Change host variable declaration to match column type. Use CAST in SQL.
Example
PIC 9(5) for DECIMAL(10,2) column