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


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 -440

   
 
  • Causa
    • NO routine-type BY THE NAME routine-name HAVING COMPATIBLE ARGUMENTS WAS FOUND.

      This occurs in a reference to routine (stored procedure or function) routine-name, when DB2 cannot find a function or stored procedure it can use to implement the reference.

      There are several reasons why this could occur.
      • routine-name was either incorrectly specified or does not exist in the database.
      • A qualified reference was made, and the qualifier was incorrectly spelled.
      • A user's current path does not contain the schema to which the desired function belongs, and an unqualified reference was used.
      • The wrong number of arguments were included.
      • For functions, the data types of one or more of the arguments is incorrect.
      • The routine invoker is not authorized to execute the routine.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Fix the problem and retry.
      This could involve a change to the SQL statement, the addition of new routines or a change to the user's current path.

      SQLSTATE: 42884

© Copyright IBM Corp.