Unanswered: The identified cursor is not open error
one of my customer says that he get the 'The identified cursor is not open error ' for the FOR loop statement, while executing a sql procedure!!!! I referred the DB2 document and it says it uses implicit cursor for the FOR loop. But this should not, obviously, cause 'cursor not open' error. I am wondering how he gets this error. Anyone experienced it before.
DB2 details : DB2 v8.1 on Aix system
SQLSTATE 24501: The identified cursor is not open error for the following statement FOR cur_screen_out AS SELECT