Yes, you can declare a cursor using the FOR UPDATE OF clause.
EXEC SQL DECLARE CURUPDT1 CURSOR FOR SELECT NAME,SEQ FROM IBMGRP.MYNAM WHERE SEQ = :WS-SEQ FOR UPDATE OF NAME END-EXEC.
Here, we can update the NAME field of the MYNAM table.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!