I'm getting the SQL Error below and have tried everything and I'm stumped - can anyone help????? - all info is below.
Any suggestions would be appreciated.....
DSNT408I SQLCODE = -440, ERROR: NO FUNCTION BY THE NAME DEVDISD.JXFNFDT
HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH
Explanation: 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 SQL 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.
I have checked the following:
1. "<routine-name>" was either incorrectly specified or does not exist in the database.
It's in the database as shown below:
F E E C P Q S P E External
Sel Schema Name Specific Name O T Parms T A F S F L R T S Name
* * * * * * * * * * * * * * * *
---- -------- -------- ------------------ - - ------ - - - - - - - - - --------
DEVDISD JXFNFDT JXFNFDT E S 3 N E N D Y M N M D JXSPFDT
1. Qualifier incorrectly spelled - No see above
2. SQL path not correct - I used a qualified call so the path is irrelevant.
Here is the call:
SELECT DEVDISD.JXFNFDT('THD', '2008-12-02', '17.00.00') FROM SYSIBM.SYSDUMMY1;
1. Wrong number of arguments
No - here's the way db2 sees it:
Parameters for Function DEVDISD.JXFNFDT(JXFNFDT)
E - Data type I - Interpretation
S Parameter name T Ord Data type L T Max length Scale
* * * * * * * *
-- ------------------ - ------ -------------------- - - ----------- ------
C 0 CHAR N N 10 0
P 1 CHAR N N 3 0
P 2 CHAR N N 10 0
P 3 CHAR N N 8 0
1. For functions, the data types of one or more of the arguments is incorrect.
As you can see in 3 and 4 above the arguments are the correct.
Thanks for any help you may give....
Administrative Office of the Courts (AOC)
[login to unmask email]<mailto:[login to unmask email]>
The Metric Law of Least Resistance: "The more human effort required to calculate a metric, the less often (and less accurately) it will be calculated, until it is abandoned or ignored altogether."
* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html