SQL - SQLCODE's - Códigos negativos -454


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -454

   
 
  • Causa
    • THE SIGNATURE PROVIDED IN THE CREATE FUNCTION STATEMENT FOR function-name 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 DB2 SQL Reference for the details on the uniqueness of a function.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • 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).

      SQLSTATE: 42723

© Copyright IBM Corp.