Overview
- A comprehensive guide to developing applications that use DB2 UDB
- Leveraging Visual Studio in DB2 UDB development: RDO, ADO, OLE DB, and stored procedures
- Application development for DB2 UDB using MTS and IIS
- The complete guide to application development with IBM's world-class DB2 Universal Database and Microsoft's Visual Studio development tools
- Leverage the power of the ActiveX Data Objects (ADO) programming model
- Create high-performance distributed and Web-centered database applications
IBM's DB2 Universal Database Version 7.1 is the perfect enterprise database for Windows applications utilizing Microsoft's Distributed interNet Applications (DNA) architecture — and Windows 2000/NT is the fastest growing platform for DB2 development. Now, there's a complete, authoritative guide to enterprise development with DB2 UDB 7.x and Microsoft's Visual Studio 6.0: DB2 Universal Database in Application Development Environments!
In this book, a team of IBM DB2 experts cover every key concept and technology DB2 and Visual Studio developers need to master in order to build robust, high-performance DB2 database applications. Compare DB2's key application programming interfaces, including embedded SQL, DB2 Call Level Interface, ODBC, JDBC, SQLJ, native DB2 UDB APIs, and Microsoft's Data Objects — DAO, RDO, and ADO.
Discover how to incorporate DB2's powerful server-side features into your application designs — including constraints, user-defined distinct types, large objects, user-defined functions, and stored procedures. Next, using both Visual Basic and Visual C++, leverage the power of DB2 with Microsoft's ActiveX Data Objects (ADO) programming model. Coverage includes:
- DB2 transaction processing using Microsoft Transaction Server (MTS)
- Using Active Server Pages (ASP) to build Web database applications for Microsoft's Internet Information Server
- Tuning application performance: refining SELECT statements, managing concurrency, temporary tables, partitioning, and other key techniques
- Database security considerations
No matter what kind of enterprise database applications you're building, IBM's DB2 UDB and Microsoft's Visual Studio are an outstanding combination — and this book is all you need to leverage them both!