Prepared Statements and parameter markers

If you feel your SQL (from JDBC or CLI) is right but DB2 is still giving you an SQLCODE=-418, SQLSTATE=42610 error, try casting all your parameter markers to the right data types, that should fix the errors.