KFAA30120-E
A aa....aa function "bb....bb" cannot be specified in the cc....cc. (query number = dd....dd, ee....ee) (M+J+O)
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.