Informix updatable cursors – PB Docs 2021

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;

DECLARE emp_curs CURSOR FOR

SELECT emp_id, emp_name FROM Employee

WHERE emp_state = :sle_1.text

FOR UPDATE;

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2021

PB Docs 2021 Powerbuilder Documentation 2021

August 21, 2023

Was this article helpful?

Connection Information