KFAA31372-E


      
         An error occurred when an SQL statement that uses hash tables was executing. <SQLSTATE: 5100J>

         
            
               aa....aa: Cause of the error

               
                  
                     
                        INSUFFICIENT MEMORY: The adb_sql_exe_hashtbl_area_size operand value (hash table area size) is too small for the executed SQL statement.

                     

                  

               

            
            
               bb....bb: 

               
                  Maintenance information

               

            
            
               cc....cc: 

               
                  Maintenance information

               

            
            
               dd....dd: 

               
                  Maintenance information

               

            
            
               S: 

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

               

            
            
               Action:

               
                  Specify a larger value in the adb_sql_exe_hashtbl_area_size operand in the server or client definition.

                  If the error still occurs, take the following correction action:

                  
                     
                        If the error occurs when executing a SQL statement that specifies a GROUP BY clause, use a grouping method specification. For details about grouping method specifications, see Specification format and rules for GROUP BY clauses in the manual HADB SQL Reference.