Previous Topic: IDCMSCOP03 - "NO UPDATE" was specified, but dataview dvw-name is updated or DELETEd in the scope of the FOR constructNext Topic: IDCMSCOP05 - The FOR construct is specified with an ORDERED clause and has dataview updates or DELETEs in its scope. To support this, dataview dvw-name must have a ROWID

Compile (CM) Messages › › 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

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

Reason:

Informational. Depending upon the DB2 release, updating an index column can cause that index not to be used for row retrieval. This can lead to performance degradation.

Action:

If your release of DB2 has this restriction, be certain that it is necessary to update column column-name and to access the table by that same column. If possible, change the access path or change the scope of the updates in the FOR construct.