-454   THE SIGNATURE PROVIDED IN THE CREATE FUNCTION STATEMENT FOR function-name MATCHES THE SIGNATURE OF SOME OTHER FUNCTION ALREADY EXISTING IN THE SCHEMA

Explanation

The signature consists of the function name (function-name), the number of parameters defined for the function, and an ordered list of the types of the parameters (without regard to any parameters of the types). In this case there is a function already in the schema and the existing function has the same signature as the function being created. See the SQL Reference for the details on the uniqueness of a function.

System action

The statement cannot be processed.

Programmer response

Determine if the existing function already provides the appropriate functionality. If not, change the signature of the new function. One way to do that is to change the function name.

SQLSTATE

42723