DB2 Universal Database v8 Application Development Certification Guide, Second Edition

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 Cer