-483   IN CREATE FUNCTION FOR function-name STATEMENT, THE NUMBER OF PARAMETERS DOES NOT MATCH THE NUMBER OF PARAMETERS OF THE SOURCE FUNCTION

Explanation

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:
  • 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.
  • 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 processed.

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:
  • fix the input parameter list
  • 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.

SQLSTATE

42885