KFAA31600-E


      
         aa....aa cannot be done because of bb....bb. <SQLSTATE: 42I75>

         
            
               aa....aa: Operation resulting in an error

               
                  
                     
                        define index: Index definition

                     

                     
                        alter table: Changing table definitions

                     

                     
                        create table: Table definition

                     

                     
                        create foreign table: Defining a foreign table

                     

                  

               

            
            
               bb....bb: Cause of the error

               
                  
                     
                        not specify "EMPTY":

                        If the EMPTY option was not specified

                     

                     
                        DEFAULT clause:

                        The DEFAULT clause is specified

                     

                     
                        the length of varchar column exceeds 32,000 bytes:

                        A VARCHAR-type column whose defined length exceeds 32,000 bytes is specified

                     

                     
                        an array-type column cannot be defined in a row store table:

                        An array-type column is defined in the row store table

                     

                     
                        a unique constraint cannot be defined in a table that defines array-type columns:

                        Uniqueness constraints are defined on tables that defines array-type columns.

                     

                     
                        an array-type column cannot be added to a row store table:

                        An attempt was made to add an array-type column to a row store table.

                     

                     
                        an array-type column cannot be added to a table that defines a B-tree index:

                        An attempt was made to add an array-type column to a table with a B-tree index defined.

                     

                     
                        a B-tree index cannot be defined in a table that defines array-type columns:

                        An attempt was made to define a B-tree index on a table that has an array-type column defined.

                     

                     
                        an archivable multi-chunk table cannot be defined using the cloud storage facility:

                        When using the cloud storage facility, an attempt was made to define an archivable multi-chunk table.

                     

                     
                        a text index cannot be defined using the cloud storage facility:

                        When using the cloud storage facility, an attempt was made to define a text index.

                     

                     
                        the struct data is specified: 

                        The STRUCT type is specified

                     

                     
                        the string data is specified: 

                        The STRING type is specified.

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  
                     
                        If bb....bb is not specify "EMPTY"

                        Re-execute the CREATE INDEX statement with the EMPTY option specified.

                     

                     
                        If bb....bb is DEFAULT clause

                        Delete the specified DEFAULT clause. The DEFAULT clause cannot be specified in an ALTER TABLE statement.

                     

                     
                        If bb....bb is the length of varchar column exceeds 32,000 bytes

                        In the ALTER TABLE statement, CREATE TABLE statement, or CREATE FOREIGN TABLE statement, a VARCHAR type column cannot be specified if the defined column length exceeds 32,000 bytes. Correct the SQL statement.

                     

                     
                        If bb....bb is an array-type column cannot be defined in a row store table

                        When defining an array-type column, the table must be defined as a column store table. You cannot define an array-type column in the row store table. Correct the CREATE TABLE statement.

                     

                     
                        If bb....bb is a unique
                           constraint cannot be defined in a table that defines array-type
                           columns

                        Uniqueness constraints cannot be defined when defining array-type columns. Correct the CREATE TABLE statement.

                     

                     
                        If bb....bb is an
                           array-type column cannot be added to a row store table

                        Array-type columns can only be added to a column store table. Array-type columns cannot be added to the row store table. Correct the ALTER TABLE statement.

                     

                     
                        If bb....bb is an array-type column cannot be added to a table that defines a B-tree index

                        Array-type columns cannot be added to tables with B-tree indexes defined. Correct the ALTER TABLE statement.

                     

                     
                        If bb....bb is a B-tree index cannot be defined in a table that defines array-type columns

                        B-tree indexes cannot be defined for tables with array-type columns defined. Correct the CREATE INDEX statement.

                     

                     
                        If bb....bb is an archivable multi-chunk table cannot be defined using the cloud storage facility

                        If you are using the cloud storage facility, you cannot define an archivable multi-chunk table. Correct the ALTER TABLE or CREATE TABLE statements.

                     

                     
                        If bb....bb is a text index cannot be defined using the cloud storage facility

                        If you are using the cloud storage facility, you cannot define a text index. Correct the CREATE INDEX statement.

                     

                     
                        If bb....bb is the struct data is specified

                        Columns of the STRUCT type cannot be added or defined. Correct the ALTER TABLE or CREATE TABLE statements.

                     

                     
                        If bb....bb is the string data is specified

                        Columns of the STRING type cannot be added or defined. Correct the ALTER TABLE or CREATE TABLE statements.

                     

                  

                  
Note

                     
                        
                           For details about the CREATE INDEX statement, see CREATE INDEX (defining an index) in the manual HADB SQL Reference.

                        

                        
                           For details about the ALTER TABLE statement, see ALTER TABLE (alter table definition) in the manual HADB SQL Reference.

                        

                        
                           For details about the CREATE TABLE statement, see CREATE TABLE (define a table) in the manual HADB SQL Reference.

                        

                        
                           For details about the CREATE FOREIGN TABLE statement, see CREATE FOREIGN TABLE (defining a foreign table) in the manual HADB SQL Reference.