store procedure error

[Ramchandra]

Hi,

i am getting error while executing the store procedure

db2 "CALL CRS.UPDATE_DEAD _RECORD2(')"
SQL0444N Routine "*_RECORD2" (specific name "SQL08022116510 3852") is
implemented with code in library or path
"...tine/sqlproc/NDB_PROD/CRS/P6510378", function "*" which cannot be
accessed. Reason code: "4". SQLSTATE=42724

has anyone got this error ??


Regards
Ramchandra

[Serge Rielau]

Re: store procedure error

Ramchandra wrote:

Hi,
>
i am getting error while executing the store procedure
>
db2 "CALL CRS.UPDATE_DEAD _RECORD2(')"
SQL0444N Routine "*_RECORD2" (specific name "SQL08022116510 3852") is
implemented with code in library or path
"...tine/sqlproc/NDB_PROD/CRS/P6510378", function "*" which cannot be
accessed. Reason code: "4". SQLSTATE=42724
>
has anyone got this error ??

That's odd. Which version of DB2 is this?

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Ramchandra]

Re: store procedure error

On Jul 9, 6:57 pm, Serge Rielau <srie...@ca.ibm .comwrote:

Ramchandra wrote:

Hi,

>

i am getting error while executing the store procedure

>

db2 "CALL CRS.UPDATE_DEAD _RECORD2(')"
SQL0444N  Routine "*_RECORD2" (specific name "SQL08022116510 3852") is
implemented with code in library or path
"...tine/sqlproc/NDB_PROD/CRS/P6510378", function "*" which cannot be
accessed.  Reason code: "4".  SQLSTATE=42724

>

has anyone got this error ??

>
That's odd. Which version of DB2 is this?
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

db2 v8.2 fp16

i have solved this by droping the procedure and creating it again.