View Poll Results: how can i get over this error?
- 0. You may not vote on this poll
it is used in IM scorer
It may be a script
Thread: Error SQL0440N, SQLSTATE=42884
04-14-04, 06:27 #1Registered User
- Join Date
- Apr 2004
Unanswered: Error SQL0440N, SQLSTATE=42884
I got an error message SQL0440N saying that
No authorized routine named "DM_IMPAPPLDATA" of type "FUNCTION"
having compatible arguments was found. SQLSTATE=42884.
when i executed the command DM_IMPAPPLDATA
Last edited by vinu; 04-14-04 at 08:26.
04-14-04, 06:42 #2Super Moderator
- Join Date
- Aug 2001
Re: Error SQL0440N, SQLSTATE=42884
See if the error message description makes sense :
SQL0440N No function by the name "<function-name>" having
compatible arguments was found in the function path.
Explanation: This occurs in a reference to function
"<function-name>", where "<function-name>" can refer to a method,
when the database manager cannot find a function or method it can
use to implement the reference. There are several reasons why
this could occur:
o "<function-name>" was either incorrectly specified or does
not exist in the database.
o A qualified reference was made, and the qualifier was
o The user's function path does not contain the schema to which
the desired function or method belongs, and an unqualified
reference was used.
o The wrong number of arguments were included.
o The right number of arguments were included, but the data
types of one or more of the arguments is incorrect.
o The function does not exist in the database with a create
timestamp earlier than the time the package was bound
(applies to static statements).
o The mutator method corresponding to an attribute assignment
used in an UPDATE statement could not be found. The data
type of the new value for the attribute is not a data type
that is the same or promotable to the data type of the
User Response: Fix the problem and retry. This could involve
catalog access, change to the statement, the addition of new
functions, and/or change to the function path.
sqlstate: 42884Visit the new-look IDUG Website , register to gain access to the excellent content.