Declare the cursor using the WITH HOLD option: EXEC SQL DECLARE EMPLUPDT CURSOR WITH HOLD FOR SELECT EMPNO, LASTNAME, PHONENO, JOBCODE, SALARY FROM TEMPL FOR UPDATE OF SALARY Open the cursor and fetch ...

In situations that you need to update data from a table, using data that exists in another table, there are several approaches that you could do. In MySQL for example you can do updates using inner ...