DB2 Universal Database v7.1: Application Development Certification Guide
Steve Sanyal, David Martineau, Kevin Gashyna · Medical Entomology and Zoology · 2000
From the Book: Welcome to the DB2 UDB (Universal Database) V7.1 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 is an entirely new publication in the DB2 UDB Certification Series, and replaces the application development chapters in the previous editions of the DB2 UDB Certification Guide. Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of each chapter. We also provide exercises and examples with this book, to develop hands-on skills with database development. Since the focus of this book is developing database applications, it also serves as a companion to the DB2 UDB V7.1 Administration Certification Guide. However, we will also cover the fundamentals of the DB2 client/server environment, database objects, and the Structured Query Language (SQL). Organization This book consists of ten chapters and several appendices. Each chapter has a set of objectives that are presented at the beginning. We also provide additional resources for many chapters when applicable. Here is a summary of the contents of this book: Chapter 1 Introduction to Database Applications for DB2Introduces you to the DB2 client/server environment, database objects, SQL, and the basic structure of a database application. Chapter 2 DB2 Programming RoadmapDiscusses the various programming interfaces that you can use to develop applications with DB2. Chapter 3 DB2 Programming Features and StrategiesExplores features and strategies that you can use to maximize your performance, and how to utilize DB2's advanced features such as triggers and stored procedures. Chapter 4 Embedded SQL ProgrammingA guide to embedded SQL programming within DB2. Chapter 5 Administration APIA discussion of the DB2 administrative and context management APIs that allow you to perform tasks such as back up, restore, and load from within your application code. Chapter 6 CLI/ODBC and OLE DB ProgrammingWe examine the DB2 CLI/ODBC driver and also discuss programming in OLE DB (Oblect Linking and Embedding Database), using interfaces such as ADO (ActiveX Data Objects). Chapter 7 Java ProgrammingA detailed discussion of JDBC and SQLj, and how to use each. We also discuss how to write Java stored procedures and User-Defined Functions (UDFs). Chapter 8 Net.DataAn introduction to programming with an easy-to-use Web application development environment provided with DB2. Chapter 9 Perl ProgrammingDiscusses writing Perl scripts to access DB2 databases using the Perl DBI (Database Interface). Chapter 10 DB2 ExtendersA guide to extending DB2 functionality using DB2 Extenders products. This includes Text Extender, Net Search Extenders, Audio, Image, and Video (AIV) Extenders, and XML Extender. Appendix A Test Objectives Appendix B Sample Exam Appendix C DB2MALL Database Appendix D Troubleshooting Techniques Exercises are provided for many of the chapters on the companion CD-ROM. Unfortunately, due to time constraints, we were not able to provide these exercises in the book. Please be sure to examine the CD-ROM for the exercises and samples, which illustrate many DB2 features that we discuss in this book. Certification Exam This book can be used as a self-study guide to prepare for the DB2 UDB Certification Exam for Application Development. Experience with DB2 UDB V7.1 is the best way to prepare for any of these certification exams. The exam for DB2 UDB focuses on general concepts covered in this book. We have included additional detail for your benefit, but this is not needed for the exam. NoteMore information about DB2 UDB certification can be found at http://www.ibm.com/certify.Contents of CD-ROM We have included a CD-ROM with DB2 trial software and additional development tools. Please refer to the readme.txt file on the CD-ROM for details on each item. Included on the CD-ROM are the following software packages: DB2 UDB V7.1 Enterprise Edition Try-and-Buy Version DB2 UDB V7.1 Text Extender DB2 UDB V7.1 Net-Search Extender DB2 UDB V7.1 Audio, Image, and Visual Extenders DB2 UDB V7.1 XML Extender DB2 Perl DBI Driver, DBD::DB2 Version 0.73 DB2 OLE DB Driver Net.Data V7.1 To fit all of these packages onto a single CD-ROM, we only included the U.S. English versions of each piece of software. In addition, we included chapter-specific samples and exercises under the \Book directory structure. DB2 Mall Database We created a database for an online mall to be used with this book. The name of the database is DB2MALL, and in Appendix C, we describe how to create this database. 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 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: http://www.software.ibm.com/data/db2/library These books provide a wealth of information about configuring and using DB2. Take advantage of them, since they are provided for 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 above 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. DB2 Resources on the Internet Here are several resources on the Internet that are invaluable for DB2 documentation and product support: Sites Official DB2 site at IBM: http://www.software.ibm.com/data/db2 DB2 Technical Library: http://www.software.ibm.com/data/db2/library International DB2 Users Group: http://www.idug.org DB2 Magazine: http://www.db2mag.com FTP DB2 Fixpaks: ftp://ftp.software.ibm.com/ps/products/db2/fixes DB2 Tools: ftp://ftp.software.ibm.com/ps/products/db2/tools DB2 Extenders Fixpaks: ftp://ftp.software.ibm.com/ps/products/db2extenders/fixes/ news.software.ibm.com ibm.software.db2.scholars ibm.software.db2.udb.eee ibm.software.db2.udb.windows2000 Usenet comp.databases.ibm-db2 How This Book Was Created The four authors of this book are DB2 service analysts at the IBM Toronto Lab. From our experience with tackling thousands of questions and technical problems from DB2 customers, we strived to put together a publication that will help readers reduce the learning curve of DB2. In addition, using our experience with the DB2 UDB product, we have demonstrated useful techniques and highlighted features that will increase the functionality and performance of your database applications. Most of the material in this book is newly written; however, some of the contents include updated portions from the DB2 UDB V6.1 Certification Guide. About the Authors 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.