logo  
Google
 

DB2 SQL-Error: -483

SQLState: 42885

Short Description: IN CREATE FUNCTION FOR STATEMENT THE NUMBER OF PARAMETERS DOES NOT MATCH THE NUMBER OF PARAMETERS OF THE SOURCE FUNCTION

An attempt is being made to CREATE a user-defined function function-name which is sourced on another function. One of the following situations has been identified: v The SOURCE clause uses a function-name (input parameter list) to identify the source function, and the number of types in the list is different from the number of parameters of the function being created. v The SOURCE clause uses different syntax to identify the source function, and the number of types of that function is different from the number of parameters of the function being created.System action: The statement cannot be executed. Programmer response: The number of parameters for the SOURCE function and for the function being created must be the same. The identification of the SOURCE function needs to be changed to: v fix the input parameter list v correct the function name or function specific name to identify the proper function. It is also possible that the SQL path needs to be corrected in order for correct function resolution to occur.

 <-  BACK TO INDEX