Positioned UPDATE/DELETE

Using positioned updates/deletes with named database cursors.

The "WHERE CURRENT OF cursor-name" clause in UPDATE and DELETE statements is not supported by all database engines.

Table 1. Database server support of WHERE CURRENT OF
Database Server Type WHERE CURRENT OF support
IBM® DB2® LUW Yes, see details
IBM Informix® Yes, see details
IBM Netezza No, see details
Microsoft™ SQL Server Yes, see details
Oracle® MySQL No, see details
Oracle Database Server Emulated, see details
PostgreSQL Yes, see details
SAP® ASE Yes, see details
SAP HANA® No, see details
SQLite No, see details

Some database drivers can emulate WHERE CURRENT OF mechanisms by using rowids, but this requires additional processing. You should review the code to disable this option.

The standard SQL solution is to use primary keys in all tables and write UPDATE / DELETE statements with a WHERE clause based on the primary key:
DEFINE rec RECORD
           id    INTEGER,
           name  CHAR(100)
     END RECORD
BEGIN WORK
  UPDATE CUSTOMER SET CUSTNAME = rec.name
        WHERE CUSTID = rec.id
  ...
COMMIT WORK