KFAA30801-E


      
         One of the following errors occurred:

         
            
               An overflow occurred in operation aa....aa using numeric data type bb....bb. <SQLSTATE: 22003>

            

            
               An overflow occurred in operation aa....aa using datetime data type bb....bb. <SQLSTATE: 22008>

            

         

         
            
               aa....aa: Type of operation that generated the overflow

               
                  
                     
                        addition: Addition

                     

                     
                        subtraction: Subtraction

                     

                     
                        multiplication: Multiplication

                     

                     
                        division: Division

                     

                  

               

            
            
               bb....bb: Data type that generated the overflow

               
                  
                     
                        BIGINT: BIGINT type

                     

                     
                        INTEGER: INTEGER type

                     

                     
                        DECIMAL: DECIMAL type or NUMERIC type

                     

                     
                        DOUBLE PRECISION: DOUBLE PRECISION type or FLOAT type

                     

                     
                        DATE: DATE type

                     

                     
                        TIME: TIME type

                     

                     
                        TIMESTAMP: TIMESTAMP type

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  Correct the SQL statement so that no overflow occurs.

                  Note that this error message may be output when the scalar function TIMESTAMPADD is executed. In that case, aa....aa will output addition and bb....bb will output the data type of the result of the scalar function TIMESTAMPADD. However, if QUARTER or WEEK is specified for the datetime unit and an overflow occurs in the multiplication before the added value is added, aa....aa will output multiplication and bb....bb will output INTEGER.