When working with OpenESQL ROWSET POSITIONING, the SQL Update or Delete may fail. For example:

EXEC SQL DECLARE CURSORA CURSOR WITH HOLD 
    WITH ROWSET POSITIONING FOR 
        SELECT COLA 
        FROM TABLEA
        FOR UPDATE OF
        COLA
END-EXEC

EXEC SQL 
     OPEN CURSORA 
END-EXEC

EXEC SQL 
    FETCH NEXT ROWSET FROM CURSORA
        FOR 10 ROWS
        INTO :WS-COLA
END-EXEC

EXEC SQL
    DELETE FROM TABLEA
    WHERE CURRENT OF CURSORA
    FOR ROW 1 OF ROWSET
END-EXEC

The SQL DELETE may fail.

Full article: https://portal.microfocus.com/s/article/KM000016423