KFAA30119-E

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.