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;