How to Call DB2 Stored Procedures in Visual Basic 6.0 Applications

This article uses samples to teach DB2 for OS/390 database administrators and stored procedure authors how to create and run their own Visual Basic, client-side tests for their server-side stored procedures.

Judith Myerson (jmyerson@bellatlantic.net), Systems Architect and Engineer, IBM

Judith M. Myerson is a systems architect and engineer. Her areas of interest include middleware technologies, enterprise-wide systems, database technologies, application development, network management, distributed systems, component-based technologies, and project management. You can contact her at jmyerson@bellatlantic.net.


developerWorks Contributing author
        level

Sarah Packowski, Architect, EMC

Sarah Packowski is one of the architects of the DB2 application enabling interfaces.



13 March 2003

This article uses samples to teach IBM® DB2® for OS/390® database administrators and stored procedure authors how to create and run their own Visual Basic, client-side tests for their server-side stored procedures.

If you are a database administrator or stored procedure author for IBM DB2 for OS/390 and z/OS™, you probably use server-side tests (in COBOL) to test your server-side stored procedures. However, there are also benefits to taking the extra step in running some simple, client-side tests. By doing this, you can be aware of complications arising from communication or system problems related to stored procedures before client-side application developers try to use those stored procedures.

For example, if the database server is DB2 for OS/390 or z/OS, the complications that might arise include TCP/IP services being down or problems with the SQL stored procedure builder/processor DSNTPSMP. Creating these client-side tests can give you a better understanding of the way in which your database and stored procedures are being used (which might affect system and stored procedure design and implementation choices).

Finally, the experience of creating and running client-side tests help you bridge the communication gap that sometimes develops between you and the client-side application developers.

Highlights include:

  • Sample 1: Calling a stored procedure
  • Sample 2: Navigating a result set
  • Sample 3. Navigating multiple result sets
  • Sample 4: Calling a stored procedure that takes one parameter
  • Sample 5: Calling a stored procedure with multiple parameters
  • Appendix A. Unattended batch processing
  • Appendix B. Adding a graphical user interface
  • Appendix C. Sample stored procedures in COBOL

Downloads

DescriptionNameSize
Sample Code filessampleCode.zip6KB
Article in PDF format0303packowski.pdf140KB

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=224928
SummaryTitle=How to Call DB2 Stored Procedures in Visual Basic 6.0 Applications
publish-date=03132003