KFAA30166-E

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.