Informix updatable cursors

To declare an updatable cursor, use the FOR UPDATE keywords in the declaration.

Example

This statement uses the FOR UPDATE syntax to declare an updatable cursor:

DECLARE emp_curs CURSOR FOR
   SELECT emp_id, emp_name FROM Employee
   WHERE emp_state = :sle_1.text
   FOR UPDATE;