Connecting to Your Database
Using Embedded SQL with Informix

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;