logo  
Google
 

DB2 SQL-Error: -454

SQLState: 42723

Short Description: THE SIGNATURE PROVIDED IN THE CREATE FUNCTION STATEMENT FOR MATCHES THE SIGNATURE OF SOME OTHER FUNCTION ALREADY EXISTING IN THE SCHEMA

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 executed. Programmer response: Determine if the existing function already provides the functionality desired. If not, then the new functionÂ’s signature will have to be changed (e.g. change the function name).

 <-  BACK TO INDEX