DB2 CHAR to VARCHAR conversion error – PB Docs 2022

Symptom

Connecting to a DB2 Version 10 database using the Rocket Shadow
ODBC 7.3 driver and getting the following error when using a Remote
Procedure Call (RPC) to execute a stored procedure:

This error didn’t occur with the Rocket Shadow ODBC 7.2
driver.

Environment

Cause

The Rocket Shadow 7.3 driver enforces a stricter type mapping than
IBM does. DB2 allows a CHAR to VARCHAR type mapping.  However the Rocket
Shadow 7.3 driver does not.  

It should also be noted that the Rocket JDBC drivers do an
automatic rebind for RPCs whereas the ODBC drivers do not.

Solution

Use the database parameter RPCRebind=1.