KFAA30601-E


      
         The table name, index name, or constraint name specified in one of the following SQL statements is already in use: <SQLSTATE: 42I13>

         
            
               ALTER
                  TABLE statement

            

            
               CREATE TABLE
                  statement

            

            
               CREATE INDEX
                  statement

            

            
               CREATE VIEW
                  statement

            

         

         This also applies to the indexes and the constraint names that HADB attempted to
            automatically define according to the specified uniqueness constraint definition. In addition, this also applies to the indexes that HADB attempted to define for
            archive range columns according to the chunk-archive specification.

         
            
               aa....aa: 

               
                  Schema name

               

            
            
               bb....bb: 

               
                  Table identifier, index identifier, or constraint name

               

            
            
               cc....cc:

               
                  
                     
                        table: Table

                     

                     
                        index: Index

                     

                     
                        constraint: Constraint

                     

                     
                        an
                           archive
                           range
                           column: Archive range column

                     

                  

               

            
            
               S: 

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

               

            
            
               Action:

               
                  
                     
                        If cc....cc is table, index, or constraint

                        Correct the table name, index name, or constraint name specified in the SQL statement.

                     

                     
                        If cc....cc is an
                           archive range column

                        The index identifier specified for RANGEINDEXNAME in the chunk-archive specification is already used.
                           Correct the specified index identifier.