KFAA31373-E


      
         There is an error in the specification format of scalar function aa....aa.

         
            
               aa....aa: 

               
                  Scalar function name

               

            
            
               bb....bb: Cause of the error

               
                  
                     
                        data length insufficient: The result data is too short. <SQLSTATE: 22001>

                     

                     
                        overflow: An overflow occurred. <SQLSTATE: 22003>

                     

                     
                        format: There is an error in the character string format of the data to be converted. <SQLSTATE: 22018>

                     

                     
                        value: The value of the data to be converted is invalid. <SQLSTATE: 22018>

                     

                     
                        out of range: A value outside of the range that can be converted to the elements specified in the format specification is specified in the target data. <SQLSTATE: 22522>

                     

                  

               

            
            
               S: 

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

               

            
            
               Action:

               
                  Correct the SQL statement.

                  Note that this error might be output by a CONVERT scalar function that was generated internally when viewed tables defined prior to upgrading the version are searched after the version is upgraded. If this occurs, re-define the viewed table. For details about the conditions that generate the scalar function CONVERT, see Notes on version upgrading in Upgrading the HADB server version in Building a System of the HADB Setup and Operation Guide.