RPG (IBM i / AS/400) · DB2 SQLCODE
What does SQLCODE -508 - Cursor Not Positioned on a Row mean in RPG (IBM i / AS/400)?
An UPDATE ... WHERE CURRENT OF or DELETE ... WHERE CURRENT OF was issued against a cursor that isn't currently positioned on a row - for example after a FETCH returned SQLCODE 100, or before the first FETCH was ever done.
An UPDATE ... WHERE CURRENT OF or DELETE ... WHERE CURRENT OF was issued against a cursor that isn't currently positioned on a row - for example after a FETCH returned SQLCODE 100, or before the first FETCH was ever done.
Only issue the WHERE CURRENT OF statement immediately after a FETCH that returned SQLCODE 0, and skip the update/delete whenever the previous FETCH hit end-of-data.