Using VB with stored procedure builder in DB2

Using VB with stored procedure builder in DB2

Post by Joe » Fri, 12 Oct 2001 02:04:11


Before I get started:

Win NT 4.0
VB 6.0 SP5


First, I am new to DB2, but not to VB.

I've done a little reading about DB2's Stored Procedure builder and
discovered that there is an add-in that works in VB where you can write
procedures in VB which somehow get compiled to the server.  Our company does
not have a licence to VB yet, so I have not had the chance to mess around
with this technique yet.  Has anybody used this strategy to build procedures
in DB2? Is it worth the effort?

Thanks in advance



1. Stored procedures problem using DB2 Stored Procedure Builder

 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 ?


2. FF 3111

3. using stored procedure builder in db2 7.2 udb

4. Oracle, ODBC and Apostrophe??

5. DB2 Stored Procedure Builder Questions

6. Semi additive brain teaser

7. Error in Using Debugger (Stored Procedure Builder)

8. Full-Text Searching, VBScript and Stored Procedure

9. Using Stored Procedure Builder

10. DB2 - Global Stored Procedure in Stored Procedures

11. Need VB example of call DB2 stored procedure without recordset

12. One way to call DB2 stored procedures through VB 6 with ADO/RDO

13. Getting a recordset from a DB2 Stored Procedure with ADO in VB 6