Stored procedures problem using DB2 Stored Procedure Builder 
Author Message
 Stored procedures problem using DB2 Stored Procedure Builder

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



Tue, 02 Dec 2003 02:23:27 GMT
 Stored procedures problem using DB2 Stored Procedure Builder

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/
Quote:

> 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



Tue, 02 Dec 2003 02:32:30 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Using VB with stored procedure builder in DB2

2. using stored procedure builder in db2 7.2 udb

3. DB2 - Global Stored Procedure in Stored Procedures

4. using SQL stored procedure results in stored procedure

5. Using Resultset in Stored Procedure in another stored procedure

6. Stored Procedure using another Stored Procedure

7. Using Stored Procedure's results in a Stored Procedure

8. Using the result from one stored procedure in a second stored procedure

9. Using Results Of Stored Procedure As Input Into Another Stored Procedure

10. Using stored procedures within stored procedures

11. DB2 Stored Procedure Builder Questions

12. Calling a Java Stored Procedure from another Java Stored Stored Procedure


 
Powered by phpBB® Forum Software