Getting Started with DB2 V8 and ADO using VB 6.0
Essma Hasin,
13 Feb 2003
You asked for it, you got it! Author Essma Hasin walks you through basic ADO database operations using DB2 Version 8, including how you can do many of the same functions with the Development Center Visual Studio Add-in.
Introduction
IBM® DB2® V8.1 is a great new release with numerous new enhancements in terms of engine capabilities, such as MDC (multi-dimensional clustering) and online reorg to name a few, as well as great new tools such as the Health Center, the Development Center, and the Development Add-Ins for Microsoft® Visual Studio 6.
Although the DB2 Development Add-In for Visual Basic 6 is a great tool that greatly simplifies n-tier application development, especially those applications that rely on database procedures and functions, it is critical for Visual Basic developers to understand the basics of DB2 development using the ADO programming APIs.
In this article, I will cover using the ADO object model to perform four basic database operations; namely, to select, insert, update, and delete records from a DB2 Universal DatabaseTM table using a Visual Basic client application. Where applicable, I will cover two different methods to accomplish these operations:
Using direct SQL statements
Using ADO recordset method calls