KFAA30112-E


      
         The aggregated argument specified in set function bb....bb is invalid. Another possibility is that the argument specified in window function bb....bb is invalid. <SQLSTATE: 42710>

         
            
               aa....aa: Type of function

               
                  
                     
                        set: Set function

                     

                     
                        window: Window function

                     

                  

               

            
            
               bb....bb:

               
                  Invalid set function name or window function name

               

            
            
               S:

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

               

            
            
               Action:

               
                  Correct the SQL statement according to rules for set function bb....bb or window function bb....bb. For details about the rules for set functions or window functions, see Set Functions or Window Functions in the manual HADB SQL Reference.

                  The possible errors are as follows:

                  
                     
                        Data whose data type cannot be specified for the argument indicated by bb....bb is specified

                        For the argument indicated by bb....bb, specify data whose data type can be specified.

                     

                     
                        The data type of the data specified for the argument indicated by bb....bb cannot be compared with the data type of the data specified for other arguments

                        For the argument indicated by bb....bb and other arguments, specify data whose data type can be compared. For details about comparable data types, see Set Functions or Window Functions in the manual HADB SQL Reference.

                     

                     
                        Only a single dynamic parameter is specified for the argument indicated by bb....bb

                        Use the scalar functions CAST or CONVERT to specify a dynamic parameter. Alternatively, do not use a dynamic parameter.

                        The following shows an example of specifying a dynamic parameter by using the scalar functions CAST and CONVERT.

                        
                           
                              Example of specifying a dynamic parameter by using the scalar function CAST

                              CAST(? AS CHAR(10))

                           

                           
                              Example of specifying a dynamic parameter by using the scalar function CONVERT

                              CONVERT(?, CHAR(10))