Very Computer

by **Arya** » Sat, 16 Jun 2001 03:23:27

HI
I am trying to run Stored Procedures using the DB2 Stored Procedure
utility provided with DB2. After picking up the corresponding table
and the columns when i try to run the stored procedure i get the
following message

Create stored procedure returns -444.

[IBM][CLI Driver][DB2] SQL0444N Routine "DSNTPSMP" (specific name "")
is implemented with code in library or path "", function "" which
cannot be accessed. Reason code: "". SQLSTATE=42724

Make sure that the SQL procedures processor, DSNTPSMP, is properly
installed on your DB2 for OS/390 host.

AGIN - Build failed.

Can anyone advice me as to where i might have overlooked something ?

Thanks
Arya

by **Larr** » Sat, 16 Jun 2001 03:32:30

Are you trying to build SQL SPs to run on DB2/390 V5 or V6? If you are,
did you install the prerequisite code on the S/390 side? If not, see
http://www-4.ibm.com/software/data/db2/os390/sqlproc/

> HI
> I am trying to run Stored Procedures using the DB2 Stored Procedure
> utility provided with DB2. After picking up the corresponding table
> and the columns when i try to run the stored procedure i get the
> following message

> Create stored procedure returns -444.

> [IBM][CLI Driver][DB2] SQL0444N Routine "DSNTPSMP" (specific name "")
> is implemented with code in library or path "", function "" which
> cannot be accessed. Reason code: "". SQLSTATE=42724

> Make sure that the SQL procedures processor, DSNTPSMP, is properly
> installed on your DB2 for OS/390 host.

> AGIN - Build failed.

> Can anyone advice me as to where i might have overlooked something ?

> Thanks
> Arya

Very Computer

Stored procedures problem using DB2 Stored Procedure Builder

Stored procedures problem using DB2 Stored Procedure Builder

Stored procedures problem using DB2 Stored Procedure Builder