Java Database Connectivity (JDBC)

hi,

iam using DB2 8.1 ,i need to calculate difference between two numbers and get their absolute value ,when i use abs ,am getting the following sql exception...

SQL0440N No authorized routine named "ABS" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884

SQL0440N No authorized routine named "ABS" of type "FUNCTION " having compatible arguments was found.

Explanation:

This occurs in a reference to routine "<routine-name>", when the
database manager cannot find a routine it can use to implement
the reference. There are several reasons why this could occur:

o "<routine-name>" was either incorrectly specified or does not
exist in the database.

o A qualified reference was made, and the qualifier was
incorrectly specified.

o The user's SQL 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 in the function
or method reference, but the data types of one or more of the
arguments is incorrect.

o The routine does not exist in the database with the same
function id that was used when 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
attribute.

o The routine invoker is not authorized to execute the
routine.



User Response:

Fix the problem and retry. This could involve catalog access, a
change to the statement, a grant of the execute privilege to the
routine invoker, the addition of new functions, and/or a change
to the SQL path.

sqlcode : -440

sqlstate : 42884

pls help
arvin