Previous 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 recordsNext Topic: IDCMSCOP06 - Since DVW dvw-name does not have a ROWID, a RUN-time error will occur if an update at the ENDFOR or a DELETE is attempted after the database LUW has ended

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

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

Reason:

DB2 does not allow updates in the scope of an ORDERed SELECT. To update the row, CA Ideal must have a unique set of columns (or ROWID) that corresponds to a unique index on the underlying TABLE. Since this dataview does not have a ROWID, CA Ideal cannot update the rows accessed.

Action:

Alter the dataview so that each instance of the VIEW or TABLE contains a unique ROWID. Alternately, remove the ORDERED BY clause from the FOR construct.