-589   A POSITIONED DELETE OR UPDATE STATEMENT FOR CURSOR cursor-name SPECIFIED A ROW OF A ROWSET, BUT THE CURSOR IS NOT POSITIONED ON A ROWSET

Explanation

The FOR ROW n OF ROWSET clause was specified on a positioned DELETE or UPDATE statement, but the cursor is not currently positioned on a rowset.

System action

The statement cannot be processed.

Programmer response

Issue a FETCH statement to position the cursor on the correct rowset, and then reissue the positioned DELETE or UPDATE statement. If the cursor is not defined for rowset access, redefine the cursor first.

SQLSTATE

24520