KFAA31123-E
Sort keys are duplicated in the "ORDER BY" clause. (sort key No: aa, bb) (M+J+O)
Columns used as sort keys specified in the ORDER BY clause are duplicated. <SQLSTATE: 42736>
- aa:
-
Number indicating the location of the first occurrence of the duplicated sort key
- bb:
-
Number indicating the location of the second occurrence of the duplicated sort key
- S:
-
Ignores this SQL statement.
- Action:
-
Correct the sort keys specification in the ORDER BY clause. The sort keys specified at positions aa and bb are duplicated.
Example message that is displayed:
KFAA31123-E Sort keys are duplicated in the "ORDER BY" clause. (Sort key No: 1, 2)
If the above message is displayed, the first and the second sort keys in the ORDER BY clause are the same.