KFAA30459-E

Column name aa....aa has been specified more than once in viewed table bb....bb. <SQLSTATE: 42734>

               aa....aa:

                  Column name that is duplicated

               bb....bb:

                  Name of viewed table that has a column name that is duplicated

               S:

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

               Action:

                  The action to take differs depending on whether column names are specified.

                        If column names are specified

                        Change column names so that there is no duplication.

                        If column names are omitted

                        Duplication of a column name in the viewed table is due to duplication of a column name in a query specification. Do not omit column names, which allow column names to be specified that do not include duplicates.

                  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.