KFAA31381-E


      
         An error occurred during the execution of the scalar function
            aa....aa.

         
            
               An invalid value was specified for the time zone string of the scalar function TIMEZONE. <SQLSTATE: 22007>

            

            
               The result value of the scalar function TIMEZONE
                  exceeded the range of the TIMESTAMP data type. <SQLSTATE: 22008>

            

            
               An error occurred within the library for the scalar function TIMEZONE (ICU4C library) during execution of the scalar function TIMEZONE. <SQLSTATE: 5100S>

            

         

         
            
               aa....aa: 

               
                  Scalar function name

               

            
            
               bb....bb: 

               
                  Cause of the error

               

            
            
               cc....cc: Detailed error information

               
                  For the scalar function TIMEZONE, the error code
                     (UErrorCode) that occurred in the library for the scalar function TIMEZONE can be displayed.

                  If there is no information to display, **** is
                     displayed.

               

            
            
               S:

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

               

            
            
               Action:

               
                  The following table shows the corrective action to take:

                  

                        
                        
                        
                           
                              
                                 Cause of the error 

                                 (bb....bb)

                              

                              
                                 Corrective action to take

                              

                           

                        

                        
                           
                              
                                 invalid time zone string

                              

                              
                                 An invalid value was specified for the time zone string of the
                                    scalar function TIMEZONE. Correct the
                                    value of the time zone string.

                                 For details about specifiable values for the time zone string,
                                    see Explanation of specification format in
                                    TIMEZONE in the manual HADB SQL
                                    Reference.

                              

                           

                           
                              
                                 overflow

                              

                              
                                 The result value of the scalar function TIMEZONE exceeded the range of the TIMESTAMP data type. The value specified as an argument to
                                    the scalar function TIMEZONE should be
                                    corrected to prevent overflow.

                              

                           

                           
                              
                                 others

                              

                              
                                 An error occurred in the library for the scalar function TIMEZONE. Refer to the error code output
                                    in cc....cc and remove the cause of the
                                    error. For details about the error code, see the official ICU
                                    documentation.

                                 If the output information does not clarify how to address the
                                    issue, execute the adbinfoget command
                                    to obtain troubleshooting information, and then contact the
                                    customer support center.