KFAA30122-E
The number of aa....aa in bb....bb exceeds cc....cc. (M+J+O)
One of the following clauses is invalid:
-
GROUP BY clause <SQLSTATE: 425B2>
The number of grouping columns specified in a GROUP BY clause exceeds the maximum allowed value.
-
Window partition clause <SQLSTATE: 425BG>
The number of value expressions specified in a window partition clause exceeds the maximum allowed value.
- aa....aa: Element that exceeds the maximum allowed value
-
-
grouping columns: Grouping column
-
value expressions: Value expression
-
- bb....bb: Invalid clause
-
-
"GROUP BY" clause: GROUP BY clause
-
"window partition" clause: Window partition clause
-
- cc....cc: Maximum allowed value
-
-
16: Maximum number of value expressions allowed in a window partition clause
-
64: Maximum number of grouping columns allowed in a GROUP BY clause
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Reduce the number of grouping columns specified in the GROUP BY clause. Alternatively, reduce the number of value expressions specified in the window partition clause.