Dear Friends ,

I am creating one DB2 procedure which contains 3 cursors . Now at the end of procedure i am opening all these cursors one by one.

OPEN CURSOR1;
OPEN CURSOR2;
OPEN CURSOR3;

When i execute this procedure i expect the resultset from the last cursor in the opened list(CURSOR3), but I am getting the resultset from the first opened cursor alone . Please suggest me whether all the cursors have opened in this case or only the first cursor has opened

have you defined the cursors with return - created proc with x resultsets...

Yes i defined procedure for 3 resultsets

DYNAMIC RESULT SETS 3

The question was how exactly you declared the cursors. Do you use the WITH RETURN TO CALLER or WITH RETURN TO CLIENT clause for all 3 of them?

Could you reduce the SP code to still exhibit the problem and then post it here?