KFAA31652-E


      
         A range index cannot be defined for the following columns: <SQLSTATE: 42IA8>

         
            
               A column whose type is CHAR and whose length exceeds 32 bytes

            

            
               A column whose type is VARCHAR

            

            
               A column whose type is BINARY

            

            
               A column whose type is VARBINARY

            

         

         
            
               aa....aa: 

               
                  Column name

               

            
            
               bb....bb: Reason why range index cannot be defined

               
                  
                     
                        data type is CHAR and data length is longer than 32 bytes: The data type of the column is CHAR and the data length exceeds 32 bytes.

                     

                     
                        data type is VARCHAR: The data type of the column type is VARCHAR.

                     

                     
                        data type is BINARY: The data type of the column type is BINARY.

                     

                     
                        data type is VARBINARY: The data type of the column type is VARBINARY.

                     

                  

               

            
            
               S: 

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

               

            
            
               Action:

               
                  A range index cannot be defined for the column aa....aa, so change the database design (column data type, indexed columns, index type, and so on).