Preface Welcome to the Second Edition of the DB2 Universal Database v8 Application Development Certification Guide for IBM's popular relational database servers. Whether you intend to become an IBM Certified Professional, or are looking for a hands-on resource for developing applications for DB2, read on. This book has been updated with the new features found in version 8 and also an entirely new section has been added to help you prepare for the DB2 UDB v8 Family Fundamentals Certification Exam. This book focuses on developing database applications and contains greater detail and information on application development topics than our companion book: DB2 Universal Database v8 Administration Certification Guide. We will also cover the fundamentals of the DB2 client-server environment, database objects, the Structured Query Language (SQL), concurrency, and transactions. This latter material is focused on helping you pass the DB2 UDB v8 Family Fundamentals Exam. How This Book Is Organized This book consists of three parts and several appendices. We also refer to additional resources for many chapters when applicable. The material covered in this book is geared toward becoming an IBM Certified Application Developer-;DB2 UDB v8 Family. This certification requires passing the DB2 UDB v8 Family Fundamentals Exam and the DB2 UDB v8 Family Application Development Exam. More information about DB2 UDB certification can be found at www.ibm.com/certify . Part 1 covers the material for the DB2 UDB v8 Family Fundamentals Exam, and is completely new to this edition. Our companion book, the DB2 UDB v8 Administration Certification Guide covers fundamentals material with additional detail for those who are interested in database administration. We have limited our coverage in this book to focus on passing the Fundamentals Exam and covering material that would be suitable for an application developer. Part 2 covers the material necessary to pass the DB2 UDB v8 Family Application Development Exam. Part 3 contains bonus material intended to help an application developer versed in using DB2 Extenders products. Part 1-;DB2 UDB Family Fundamentals The first part of the book focuses on the DB2 UDB v8 Family Fundamentals Exam so that a reader who wishes to become certified as a DB2 UDB v8 Application Developer can do so with this book alone. The chapters for this section are as follows: Chapter 1-;DB2 Product Overview. Introduces the DB2 suite of products. Chapter 2-;DB2 Tools and Connectivity. Discusses the suite of tools included with DB2 and how to connect to DB2 databases, where applicable. Chapter 3-;Database Objects and Security. Explores the Data Definition Language (DDL) and Data Control Language (DCL) for creating tables, views, schemas, and indexes; and controlling access to them. Chapter 4-;Data Retrieval. Discusses how to select data from tables and views. Chapter 5-;Data Modification. Discusses how to insert, update, and delete data in tables. Chapter 6-;Data Concurrency. Discusses the rules for data access for any application connected to a DB2 database. Part 2-;DB2 UDB Family Application Development Part 2 covers the material necessary to pass the DB2 UDB v8 Family Application Development Exam. Chapter 7-;DB2 Programming Roadmap. Introduces the DB2 client-server environment, database objects, SQL, and the basic structure of a database application. Chapter 8-;DB2 Programming Features and Strategies. Discusses the various programming interfaces that you can use to develop applications with DB2. Chapter 9-;Embedded SQL Programming. Provides a guide to embedded SQL programming within DB2. Chapter 10-;Administrative API. Covers the DB2 Administration and Context Management API that allows you to perform tasks such as backups, restore, and load from within your application code. Chapter 11-;CLI/ODBC Applications. Examines the DB2 CLI/ODBC driver and also discusses programming in OLE DB, using interfaces such as ADO. Chapter 12-;Java Programming. Covers JDBC and SQLj in detail, including how to use each. Chapter 13-;Perl Programming. Discusses writing Perl scripts to access DB2 databases using the Perl DBI. Part 3-;DB2 UDB Extenders Part 3 is a bonus section that explores the DB2 UDB Extenders products. Chapter 14-;DB2 Extenders. Provides an overview of DB2 Extenders products. Chapter 15-;DB2 Text Extender. Provides a guide on setting up, using, and administering DB2 Text Extenders. Chapter 16-;DB2 Net Search Extender. Provides a guide on setting up, using, and administering DB2 Net Search Extenders. Chapter 17-;DB2 AIV Extenders. Provides a guide on setting up and using DB2 AIV Extenders. Chapter 18-;DB2 XML Extender. Provides a guide on setting up, using, and administering DB2 XML Extenders. Chapter 19-;DB2 Spatial Extender. Provides a guide on setting up, using, and administering DB2 Spatial Extenders. Part 4-;Appendices Appendix A-;DB2 Universal Database v8 Certification Test Objectives. Provides a summary of the test objectives of the exam 700 (DB2 UDB v8 Family Fundamentals) and exam 703 (DB2 UDB v8 Family Application Development). Appendix B-;DB2MALL Database. Covers a simple database, called DB2MALL, which is used by our examples in this book. Appendix C-;Application Troubleshooting. Provides a brief how-to on troubleshooting database applications. Contents of CD-ROM We have included a CD-ROM with DB2 trial software. Included in the CD-ROM are the following software packages. DB2 UDB v8 Personal Edition Try-and-Buy Version Instructions to download the DB2 UDB v8 Text, Audio, Image, and Video Extenders DB2 Net Search Extenders DB2 database driver (DBD) v0.73 for Perl DB2MALL database Mall Database We have created a database for an online mall to be used with the Application Development section. The name of the database is DB2MALL, and Appendix B describes how to create it. We also provide a description of all the tables. All of our samples and exercises reference this database, so please familiarize yourself with it. We have simplified many of the tables for simplicity and clarity. Using the DB2 Online Books Throughout this book, we will often refer to the DB2 online books that are installed with every DB2 product. They can also be downloaded in PDF format from the DB2 Product and Service Technical Library at: www-3.ibm.com/software/data/db2/library/ These books provide a wealth of information about configuring and using DB2. Take advantage of them, since they are free. If you are not sure where to look for an answer to a question, there is also a Search feature provided with the online books which is also available on the Web site. We will often refer you to the DB2 online books for further background to allow us to concentrate on more detailed explanations of other topics and to describe advanced concepts.