Updating previously retrieved data in embedded SQL applications

To scroll backward and update data that was retrieved previously, you can use a combination of the techniques that are used to scroll through previously retrieved data and to update retrieved data.

To update previously retrieved data, you can do one of two things:

• If you have a second cursor on the data to be updated and the SELECT statement uses none of the restricted elements, you can use a cursor-controlled UPDATE statement. Name the second cursor in the WHERE CURRENT OF clause.
• In other cases, use UPDATE with a WHERE clause that names all the values in the row or specifies the primary key of the table. You can issue one statement many times with different values of the variables.