Unanswered: Cursor Names in ResultSets from a COBOL Stored Procedure
I am calling a DB2 Stored Procedure returning multiple Resultsets ( from different cursors ) from a Java Client. The call goes through, get successful return code, sql state etc..But when I tried to retrieve the cursor name using resultSet.getCursorName(), it returns Nulls. I am able to get the ResultSetMetaData object & retrieve all the column names correctly. So, I took out the getCursorName and tried to get the data. Now I am getting COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0115E Invalid cursor state. SQLSTATE=24000
We are running db2 z/OS V7 & connecting through DB2 Connect V8.1 FXP3.
Could anyone throw some light on the problem & help me.