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

                     

                  

               

            
            
               bb....bb: Cause of the error

               
                  
                     
                        not specify "EMPTY": The EMPTY option is not specified.

                     

                     
                        DEFAULT clause: A 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.

                     

                  

               

            
            
               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 or CREATE TABLE statement, a VARCHAR type column cannot be specified if the defined column length exceeds 32,000 bytes. Correct the SQL statement.

                        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.