KFAA96411-I


      
         The index specification for the table
            aa....aa.bb....bb (correlation name
            cc....cc) was ignored.

         If a nonexistent index name or an invalid index name was specified in the index
            specification, that index specification is ignored. Check the index name specified in
            the index specification.

         The following is a possible reason why the index specified in the index specification cannot be used:

         
            
               If the specified index is a B-tree index

               A B-tree index with null-value exclusion specification was specified and the index search range contains a null value.

            

            
               If the specified index is a text index

               The index specified by the index specification cannot be used when HADB
                  cannot use the text index efficiently because, for example, the LIKE predicate that can be evaluated by the text index is
                  not specified.

            

         

         
            
               aa....aa: 

               
                  Schema name

               

            
            
               bb....bb: 

               
                  Table identifier

               

            
            
               cc....cc: Correlation name

               
                  If no correlation name has been specified, *** is displayed.

               

            
            
               S: 

               
                  Continues processing.