KFAA30619-E


      
         An error occurred in an SQL statement because a column name was specified more than once. <SQLSTATE: 42I18>

         
            
               aa....aa: 

               
                  Cause of the error

               

            
            
               bb....bb: Name of the column whose name was specified more than once

               
                  If the column name cannot be output, *** is displayed.

               

            
            
               S: 

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

               

            
            
               Action:

               
                  Based on the cause of the error displayed in place of aa....aa, take one of the following corrective actions.

                  

                        
                        
                        
                           
                              
                                 Cause of the error displayed for aa....aa

                              

                              
                                 Cause of the error and corrective action to take

                              

                           

                        

                        
                           
                              
                                 index

                              

                              
                                 A single column name has been specified more than once in an indexed column specified in a CREATE INDEX statement. Correct the indexed column specification.

                              

                           

                           
                              
                                 primary key

                              

                              
                                 A single column name has been specified more than once in the columns that constitute a primary key specified in a CREATE TABLE statement. Correct the specifications of the columns that constitute the primary key.

                              

                           

                           
                              
                                 foreign key

                              

                              
                                 A single column name has been specified more than once in the columns that constitute a foreign key specified in a CREATE TABLE statement. Correct the specifications of the columns that constitute the foreign key.

Cause of the error displayed for `aa....aa`	Cause of the error and corrective action to take
`index`	A single column name has been specified more than once in an indexed column specified in a `CREATE` `INDEX` statement. Correct the indexed column specification.
`primary` `key`	A single column name has been specified more than once in the columns that constitute a primary key specified in a `CREATE` `TABLE` statement. Correct the specifications of the columns that constitute the primary key.
`foreign` `key`	A single column name has been specified more than once in the columns that constitute a foreign key specified in a `CREATE` `TABLE` statement. Correct the specifications of the columns that constitute the foreign key.