KFAA30166-E
The aa....aa in the bb....bb is incorrect. (reason = cc....cc) (M+J+O)
The SQL statement specification contains one of the following errors.
-
The sort key specified in the ORDER BY clause contains one of the following errors:
• The name of a derived column (excluding a derived column that consists of a column specification only) is specified in the value expression. Alternatively, the derived column name that is derived by a set operation is specified in the value expression (even a derived column consisting of only column specifications cannot be specified). <SQLSTATE:427HC>
-
The window partition clause contains the following error:
• The value expression contains no column specification. <SQLSTATE: 427HA>
- aa....aa: Invalid specification
-
-
sort key: Sort key
-
value expression: Value expression
-
- bb....bb: Invalid clause
-
-
"ORDER BY" clause: ORDER BY clause
-
"window partition" clause: Window partition clause
-
- cc....cc: Cause of the error
-
-
not specified column: The value expression contains no column specification.
-
specified by the derived column: The name of a derived column is specified in the value expression.
-
- S:
-
Ignores this SQL statement.
- Action:
-
Correct the SQL statement.