Mirco

Hi Gerd, sorry to keep you waiting. On DB2 Z/OS (this does not apply to DB2 AIX or DB2 LUW), if a Stored Procedure have a I/O parameters you cannot use "Statement" methods to execute CALL statements. You must use PreparedStatement methods or CallableStatement methods. Here is the IBM documentation link: https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_tjvcscsp.html In any case,starting from your code,I did some tests. Here you find...

This bug is only reproducible with Db2-for-Z. How can I help you?

Hi, the stored procedure is correctly defined on the schema. If the SP has NO input parameters (example SP_ABC2) it works. If the stored procedure has input parameters (example SP_ABC) it doesn't run. I also checked SQUIRREL's "CURRENT_PATH" and it is correct.

Call Stored Procedure with input parameters on DB2 z/os