KFAA30194-E
The aa....aa cannot be specified in the "ORDER BY" clause for the query that used the bb....bb. (M+J+O)
aa....aa cannot be specified in the ORDER BY clause for a query in which bb....bb is specified.
One of the following errors occurred:
-
For a query that uses a set operation, a column name qualified in the table specification cannot be specified as a sort key. <SQLSTATE: 427B2>
-
For a query that uses a set operation, no value expression can be specified in the ORDER BY clause. <SQLSTATE: 427B6>
-
For a query that specifies SELECT DISTINCT, no value expression can be specified in the ORDER BY clause. <SQLSTATE: 427HE>
- aa....aa: Sort key specification in the ORDER BY clause
-
-
qualified column name: Column name qualified in the table specification
-
value expression: Value expression
-
- bb....bb: Constituent element specified in the query that is incompatible with aa....aa
-
-
"SET OPERATION": Set operation
-
"SELECT DISTINCT": SELECT DISTINCT
-
- S:
-
Ignores this SQL statement.
- Action:
-
Correct the SQL statement.