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

Explanation

An attempt was made to invoke a routine, but Db2 could not resolve the invocation of a routine, including the argument list, to a specific routine definition.

routine-type

The type of routine, such as FUNCTION or PROCEDURE.

routine-name or schema-name.routine-name

The name of the routine. If the originating statement references a qualified name, the routine name in the message text is qualified by the name of the schema.

Possible causes for this error include:

• The routine name was either incorrectly specified or does not exist in the database.
• A qualified reference was used, and the schema qualifier was incorrectly specified.
• The 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 was included.
• The right number of arguments was included in the routine reference, but the data type of one or more of the arguments is incorrect.
• The invoker of the routine is not authorized to execute the routine.
• CURRENT QUERY ACCELERATION was set to NONE while a passthrough-only expression was running.
• An application or SQL object attempted to use a capability that is not supported by the current application compatibility level.
  • Before the activation of function level 500 or higher, Db2 environments must use application compatibility levels from previous releases. After the activation of function level 500 or higher, the application compatibility level can be equivalent to the current function level, a lower function level in the current release, or a function level from a previous release.