Row by row processing

[badukist]

It possible something like this in stored procedures?
DECLARE CURSOR -> OPEN -> FETCH doesn't work

I've read that UPDATE CURRENT OF CURSOR ... works in stored procedures, but how to implement this?

http://www.ibphoenix.com/a558.htm

 

[badukist]

Found it!

FOR SELECT ... FROM {table} INTO ... AS CURSOR {cursor}

{calculations}
UPDATE {table} SET ... WHERE CURRENT OF {cursor}