Skip to Content
0
Jan 19, 2009 at 05:31 AM

Execute Statement with JDBC Sender

44 Views

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