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?
