DB2 Universal Database v7.1

Steve Sanyal is a software developer for the DB2 UDB Application Development Team at the IBM Toronto Lab. He is a certified IBM Solutions Expert as a DB2 UDB Application Developer and Administrator. Steve specializes in JDBC, SQLj, and CLI/ODBC on the UNIX and Intel platforms and is the Web sphere focal point on the team. Steve is also leading a project to develop Java and XML-based tools for troubleshooting application performance and problem determination. David Martineau is a staff software developer at the IBM Toronto Lab, providing technical support for the DB2 UDB Application Development Team. David has provided sample code for DB2 UDB using interfaces such as ADO, CLI, and Net.Data. Prior to 1998, David was a developer within the DB2 UDB Connect group for one year, where he primarily worked on projects to enhance the performance of ODBC. Prior to joining IBM, David was developing database engines since 1994. His work includes developing support for stored procedures, user-defined functions, and 64-bit integer support. Kevin Gashyna has been working with DB2 UDB and its predecessors since 1997. He is a certified DB2 UDB V7.1 Database Administrator, Application Developer, and Advanced Technical Expert in DRDA. Kevin is currently a staff software developer with the DB2 UDB Extended Enterprise Edition (EEE) Support Team in the IBM Toronto Lab. He has been involved in several aspects of DB2 on the UNIX and Intel platforms, including application development, connectivity, and clustered environments. Kevin also participated in the creation of the DB2 UDB V7.1 Application Development Certification Exam. Michael Kyprianou has been working with DB2 UDB and its predecessors since 1995. He is an IBM Advanced Technical Expert in DB2 DRDA and is certified in DB2 UDB Database Administration and Application Development. Michael is currently a staff programmer analyst with the DB2 UDB Application Development Team, prior to which he was team lead for the DB2 UDB Connectivity Group for two years. In these roles, Michael provided technical marketing, electronic, and on-site support to customers all over the world. Michael has also assisted at IDUG conferences offering the DB2 UDB Certification Exam.

1. Introduction to Database Applications for DB2.


Objectives. DB2 UDB Server Instances and Databases. Database Objects. SQL Concepts. DB2 Application Structure. Summary.



2. DB2 Programming Roadmap.


Objectives. Administrative API. Embedded SQL. Driver-based Application Solutions. Net.Data. DB2 Extenders. Summary.



3. DB2 Programming Features and Strategies.


Objectives. Data Manipulation Strategies. Concurrency and Transaction Management. Database Packages and Query Performance. Summary.



4. Embedded SQL Programming.


Embedded SQL Overview. Static Embedded SQL. Dynamic Embedded SQL. Comparing Dynamic SQL with Static SQL. Summary.



5. Administrative APIs.


DB2 APIs. Application Migration Considerations. Context Management APIs. Summary.



6. CLI/ODBC and OLE DB Programming.


Objectives. CLI and ODBC Overview. Setting up the CLI Environment. Basic Program Flow for a CLI Application. Advanced Programming Features. DB2 OLE DB Driver. Summary.



7. Java Programming.


Objectives. JDBC Programming. SQLj Programs. Java Stored Procedures. Java UDFs. Summary.



8. Net.Data.


Objectives. Advantages. Scripting Language. Language Environments. Performance. Summary.



9. Perl Programming.


Objectives. Advantages of Perl. Setting up the Perl Environment. Basic Program Flow. Summary.



10. DB2 Extenders.


Objectives. Text Extender. Net Search Extender. AIV Extenders. XML Extender. Summary.



Appendix A: DB2 UDB Application Development Test Objectives.


Appendix B: DB2 UDB Application Development Sample Exam.


Appendix C: DB2MALL Database.


Appendix D: Application Troubleshooting.


Obtaining an SQL Error. Isolating Error Location. Diagnostic Error Files. Tracing Facilities.



Index.