Informix updatable cursors

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

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

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

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

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 15.0

August 20, 2023

Was this article helpful?

Connection Information