Previous Topic: IDCMSCOP11 - Row_count after FOR FIRST must be an integer literal or numeric fieldNext Topic: IDCMSELX02 - Condition expression or "WHEN" postscript expected


IDCMSELX01 - Duplicate SELECT "WHEN" XXXX clauses

Reason:

Each of the following clauses:

WHEN OTHER (equivalent to WHEN NONE in a SELECT construct)

WHEN ANY

WHEN ALL (valid only in SELECT EVERY ACTION)

can appear only after all of the WHEN-condition clauses are entered for the construct and can only appear once.

Action:

Correct the errors and re-specify.