Hi
I am working on JDBC sender and trying to use Execute, following is the statement. The target system is Iseries
EXECUTE cc5ptf.SF_BSIMHP_Process2
But it is returning following error,
Database-level error reported by JDBC driver while executing statement 'EXECUTE cc5ptf.SF_BSIMHP_Process2'. The JDBC driver returned the following error message: 'com.ibm.db2.jcc.c.SqlException: java.sql.Statement.executeQuery() was called but no result set was returned. Use java.sql.Statement.executeUpdate() for non-queries.'. For details, contact your database server vendor.
Does anyone has an idea what could be the reason it.
I hope I am using the right syntax for Execute statement.
Regards
Ria