470,618 Members | 1,723 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,618 developers. It's quick & easy.

SQL0444N Reason Code 4 SQLSTATE=42724

I'm new to DB2 and am trying to execute a parameterized stored
procedure from within a VB 6.0 application. We're using DB2 WSE
version 8.2 with fixpack 10 running on a Windows Small Business Server
2003. I created the stored procedure on the DB2 server. When I call
the sp from within my VB code, it uses a DSN to connect to the
database. The DSN uses the IBM DB2 ODBC Driver. I get the following
error message:

Error: [IBM][CLI Driver][DB2/NT] SQL0444N Routine "*PATIENTS" (specific
name "SQL060124151726030") is implemented with code in library or path
"...ISITS_PATIENT", function "p_INS_VISITS_PATIENTS" which cannot be
accessed. Reason code: "4". SQLSTATE=42724

Security is set up on the database and I have ensured that the proper
groups have permissions to execute the stored procedure in question as
well as to perform SELECT and INSERT operations on the underlying
table.

All other stored procedures seem to function correctly when called from
the application. It is only with this newly created sp that I receive
the error message. All other sp's were created by the previous
developers. This is the only sp I have created and I used the
Development Center to create it.

Does anyone know what might be causing this error?

Jan 24 '06 #1
1 30467
GarthVader wrote:
I'm new to DB2 and am trying to execute a parameterized stored
procedure from within a VB 6.0 application. We're using DB2 WSE
version 8.2 with fixpack 10 running on a Windows Small Business Server
2003. I created the stored procedure on the DB2 server. When I call
the sp from within my VB code, it uses a DSN to connect to the
database. The DSN uses the IBM DB2 ODBC Driver. I get the following
error message:

Error: [IBM][CLI Driver][DB2/NT] SQL0444N Routine "*PATIENTS" (specific
name "SQL060124151726030") is implemented with code in library or path
"...ISITS_PATIENT", function "p_INS_VISITS_PATIENTS" which cannot be
accessed. Reason code: "4". SQLSTATE=42724

Security is set up on the database and I have ensured that the proper
groups have permissions to execute the stored procedure in question as
well as to perform SELECT and INSERT operations on the underlying
table.

All other stored procedures seem to function correctly when called from
the application. It is only with this newly created sp that I receive
the error message. All other sp's were created by the previous
developers. This is the only sp I have created and I used the
Development Center to create it.

Does anyone know what might be causing this error?

Take a look at the definition of the stored procedure.
Verify that the EXTERNAL library is indeed where it's supposed to be.
Also verify that DB2 has permissions to access the directory.
Is this a CLR procedure, Java, C?
One thing is for sure: The error has nothing to do with your VB app.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Private Pyle | last post: by
1 post views Thread by yogesh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.