04-29-04, 12:56 #1Registered User
- Join Date
- May 2003
Unanswered: .Net SQL0444N sql routine cannot be accessed
I'm calling a procedure from .Net and I get the following error
System.Data.Odbc.OdbcException Error [IBM][CLI Driver][DB2/NT] SQL0444N Routine "*OLIST_D" [sepcific name "Portfoliolist_D"] is implemented with code in library or path qlproc\calib01\db2admin\P0533754", function "pgsjmp" which cannot be accessed reason code 4 SQLState=42724.
This is a really strange error. I have 2 databases one live and one staging both running on the same machine.
Calib01 = Staging and Calib02=Live
The procedures work before I rebuild the database in both instances of the application. When I rebuild it fails on the live but the error message I get indicates that the code is on the staging database.
a. I don't know why this is failing in the first place
b. Does db2 look through it's catalogue and for any procedures with a specific name on a machine, or why do I get an error message with another database name in my error.
Any help greatly appreciated.
04-29-04, 15:13 #2Registered User
Originally Posted by gar34
- Join Date
- Mar 2004
- Toronto, ON, Canada
select IMPLEMENTATION from syscat.procedures where SPECIFICNAME = 'Portfoliolist_D'
You should be able to use "ALTER PROCEDURE <procname> EXTERNAL NAME '<newname>'" to fix it, although I'm not clear on exactly what you've done to get into this situation!--
DB2 Database Consultant