DSXchange

Hi guys,
I am trying to run db2 stored procedure in parallel job using stored procedure stage in unix platform.
I am able to run sample stored procedure which returns two columns in single result set.
But not able to manage multiple result sets. Job is getting aborted with invalid cursor state error.Do I need to check for any options in stage properties?

No, STP stage simply cannot handle the multiple resultsets. What you can do is to use Java stage with JDBC connection to the database. Especially for DB2, you can use getMoreResult method to close the first reuslt set and open the second result set.

Hi Istsaur,Thanks for your reply. Java stage is a plug in kind of stage right? So I need to plug in stage and work which needs more time. Is there any alternative for reading multiple result sets into datasets