we are trying to execute stored procedures on our DB2 with Planet Press Connect Workflow / Planet Press Connect.
The stored procedure is very easy, it only returns the sum of two values.
If I execute the procedure direct with the System I Navigator, the result is correct.
With the script in the datamapper:
resultSet = sqlConnection.createStatement().executeQuery(“CALL XYZ.SP_SUM_NUMS_TST(35,35)”);
an error occurs: SQLException: No ResultSet was produced.
Normal SQL-selections are working without problems.
What can we do to solve this problem?