KFAA30119-E
In a query using a GROUP BY clause or a set function specification, the column "aa....aa" specified in a select expression, a HAVING clause or an ORDER BY clause must be specified as an argument of the GROUP BY clause or the set function. (query number = bb....bb, cc....cc) (M+J+O)
In a query using a GROUP BY clause or set function specification, column aa....aa specified in a selection expression, HAVING clause, or ORDER BY clause must be specified as an argument of the GROUP BY clause or set function. <SQLSTATE: 42746>
- aa....aa: Name of the column with the invalid column specification
-
Note that *** is displayed when no column name can be output.
- bb....bb:
-
Position number of the query that specified column aa....aa#
- cc....cc:
-
Position number of the query specification that has the referenced table in its FROM clause#
- #
-
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.
If this message is output in either of the following cases, take the corrective action described under Procedure.
-
The ALTER VIEW statement is executed.
-
A viewed table is re-created during version upgrading of the HADB server.
For details, see Re-creation of viewed tables in the event of a version upgrade in Notes on version upgrading in the HADB Setup and Operation Guide.
Procedure
-
Check viewed table definition information.
Check the CREATE VIEW statement that was used when the target viewed table was defined. You can acquire viewed table definition information by searching a dictionary table. For details about examples of searching the dictionary table, see Finding out viewed table definition information in Searching a dictionary table in the HADB Setup and Operation Guide.
-
Delete the viewed table.
Delete the target viewed table by using the DROP VIEW statement.
-
Correct the information specified in the CREATE VIEW statement.
Correct the information specified in the CREATE VIEW statement you checked in step 1.
-
Redefine the viewed table by using the CREATE VIEW statement.
Use the CREATE VIEW statement you corrected in step 3 to redefine the viewed table deleted in step 2.
If this message is output because an asterisk (*) is specified in the selection expression for the query specification in the CREATE VIEW statement, do not specify the asterisk (*). Correct the information specified in the CREATE VIEW statement to explicitly specify the column name in the selection expression for the query specification.
-