+440 NO routine-type BY THE NAME routine-name HAVING COMPATIBLE ARGUMENTS WAS FOUND

Explanation

This warning 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. Several reasons are present for this warning:

  • routine-name was incorrectly specified or does not exist in the database.
  • A qualified reference was made, and the qualifier was incorrectly spelled.
  • A user's SQL path does not contain the schema to which the 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.

System action

A valid plan or package will be created if no errors are detected. The statement is bound dynamically on each execution of the statement.

Programmer response

Fix the problem and retry. Change the SQL statement, add new routines, or change the user's SQL path.

SQLSTATE

0168L