KFAA31651-E


      
         An index cannot be defined because multiple indexed columns are
            specified. <SQLSTATE: 42IA7>

         
            
               aa....aa: Index type

               
                  
                     
                        range: Range index

                     

                     
                        text: Text index

                     

                  

               

            
            
               S: 

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

               

            
            
               Action:

               
                  
                     
                        A range index and text index cannot be changed to a
                           multiple-column index. Change the database design (the specification
                           for the indexed columns).

                     

                     
                        If you want to define range indexes for all indexed columns specified in CREATE INDEX statements, execute multiple CREATE INDEX statements specifying columns one at a time rather than specifying multiple columns with a single CREATE INDEX statement.