Stored procedure stage

anand_chal · Post by **anand_chal** » Mon Nov 07, 2011 7:49 am

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?

lstsaur · Post by **lstsaur** » Mon Nov 07, 2011 3:00 pm

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.

anand_chal · Post by **anand_chal** » Sun Nov 13, 2011 12:53 am

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