I have a batch DB2 program(PGM1) which call a store procedure(SPROC).
the PGM1 has a cusrsor defined WITH HOLD and FOR UPDATE of function. For every fetch on this cusrsor i will be calling the stored proc the after the return from SPROC the PGM1 will be updating the row with WHERE CURRENT cursor. But at this point i am hitting SQLCODE -508 ("THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT POSITIONED ON A ROW")
Can some one tell me why it is throwing this message.