DSNH126I E csectname LINE nnnn COL cc ORDER BY CANNOT BE USED WITH A FOR UPDATE OF CLAUSE

Explanation

The ORDER BY clause makes the cursor incapable of being updated.

System action

The cursor declaration is discarded.

User response

This is a Db2 restriction. You can have either an ordered cursor or a cursor that can be updated. You cannot specify both attributes for the same cursor. You might need to change your application logic.

Severity

8 (error)