logo  
Google
 

DB2 SQL-Error: -492

SQLState: 42879

Short Description: THE CREATE FUNCTION FOR HAS A PROBLEM WITH PARAMETER NUMBER IT MAY INVOLVE A MISMATCH WITH A SOURCE FUNCTION

The parameter in position number of function function-name is in error. The parameter in position number of the source function is not castable to the corresponding parameter of the function being created. If the parameter of the function being created is a table parameter then the corresponding parameter of the source function must also be a table parameter. Furthermore, the column numbers for both of the table parameters must be the same. If the parameter of the function being created is not a table parameter then the corresponding parameter of the source function must also not be a table parameter. System action: The statement cannot be executed. Programmer response: Possible corrections include: v Identify a different source function. v Change the data type of the parameter of the function being created so that the data type of the source function can be cast to this data type.

 <-  BACK TO INDEX