Previous Topic: IDCMSCOP02 - The set of rows selected can be lost in the scope of the FOR-construct by crossing an LUW boundary (for example, TRANSMIT, COMMIT/BACKOUT, CHECKPOINT/ROLLBACK)Next Topic: IDCMSCOP04 - Column column-name is referenced in the WHERE clause, updated in the scope of the FOR construct, and corresponds to a DB2 index. DB2 may not use the index to find the selected records


IDCMSCOP03 - "NO UPDATE" was specified, but dataview dvw-name is updated or DELETEd in the scope of the FOR construct

Reason:

An update or delete operation can be executed in the logical scope of a FOR construct with the NO UPDATE clause. An <<ERROR>> PROCEDURE is implicitly considered in the scope of every FOR construct.

Action:

Remove the update or delete from the scope of the FOR construct to prevent the run-time error.