KFAA30120-E

Set function bb....bb cannot be specified in cc....cc. Another possibility is that window function bb....bb cannot be specified in cc....cc. <SQLSTATE: 42714>

               aa....aa: Type of function

                        set: Set function

                        window: Window function

               bb....bb:

                  Function name

               cc....cc: Name of the clause or statement in which aa....aa is specified

                        "WHERE" clause: A WHERE clause

                        update value: Update value specified in an UPDATE statement

                        insert value: Insertion value specified in an INSERT statement

                        "FROM" clause: Search condition of joined tables in a FROM clause

                        "ORDER BY" clause: ORDER BY clause

                        "GROUP BY" clause: GROUP BY clause

                        "HAVING" clause: HAVING clause

                        sort specification: Sort specification

               dd....dd:

                  Position number of the query specification in which the table referenced by the aggregated column specification in aa....aa is specified as the FROM clause^#

               ee....ee:

                  Position number of the query specification that specified aa....aa^#

               #

                  For details about query position numbers, see 1.5 Query position numbers.

               S:

                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               Action:

                  Correct the SQL statement.