DB2 Universal Database v7.1: Application Development Certification Guide

About

Features



Description

• Copyright 2001
• Dimensions: K
• Pages: 320
• Edition: 1st

• Book
• ISBN-10: 0-13-091367-7
• ISBN-13: 978-0-13-091367-8

• Start-to-finish coverage of application development with DB2 UDB V7.1
• Authoritative preparation for IBM's new DB2 UDB Certification Exam for Application Development!
• Features, strategies, and interfaces — including SQL, CLI/ODBC, JDBC, and SQLj
• Easy Web application development with Net.Data
• DB2 Extenders: Adding functionality for text, search, multimedia, and XML
• By the DB2 experts at IBM's Toronto Lab
• Covers every DB2 V7.1 programming interface and strategy
• Includes practical application development troubleshooting techniques
• Great DB2 certification preparation: Includes a complete sample exam to assist in preparation, plus CD-ROM library of programming exercises

For application developers, IBM's DB2 Universal Database Version 7.1 delivers unprecedented power and flexibility. In this book, a team of IBM experts present every skill and technique you need to build enterprise, Web, and eBusiness applications with DB2 UDB V7.1 — and gain IBM's coveted Certified Solutions Expert certification for DB2 application development!

Start by understanding the DB2 client-server environment, database objects, the role of SQL, and the basic structure of a DB2 application. Compare the multiple programming interfaces available for DB2 application development, identifying the ones most appropriate to each project. Review IBM DB2 7.1 features and strategies for maximizing application performance and scalability, and master advanced techniques such as triggers and stored procedures.

Master embedded SQL programming within DB2; development with CLI/ODBC, and OLE DB development — including Microsoft's ActiveX Data Objects (ADO). Next, take advantage of the powerful DB2 Administration and Context Management API, which allows you to handle a wide variety of database administration tasks from within your application code. Coverage also includes:

• JDBC and SQLj: how and when to use each
• Using IBM's Net.Data scripting language to build powerful Web applications that access data from DB2 and other sources
• Accessing DB2 databases using Perl DBI
• Extending DB2 functionality using DB2 Extenders: Text Extender, Net Search Extender, Audio, Image and Video Extenders, and XML Extender.

Whatever your DB2 application, whatever your environment — UNIX, Windows, or OS/2 — this is the most thorough, authoritative development guide you can find.

About the CD-ROM

The accompanying CD-ROM contains an extensive library of hands-on programming exercises, plus the complete DB2 UDB V7.1 Enterprise Edition Try-and-Buy Version, Extenders, Perl DBI drivers, OLE DB Driver, and Net.Data V7.1 (English language versions).



Sample Content

Downloadable Sample Chapter

Click here for a sample chapter for this book: 0130913677.pdf

Table of Contents

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.

Preface

Preface

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 DB2—Introduces you to the DB2 client/server environment, database objects, SQL, and the basic structure of a database application.
• Chapter 2 DB2 Programming Roadmap—Discusses the various programming interfaces that you can use to develop applications with DB2.
• Chapter 3 DB2 Programming Features and Strategies—Explores 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 Programming—A guide to embedded SQL programming within DB2.
• Chapter 5 Administration API—A 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 Programming—We 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 Programming—A 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.Data—An introduction to programming with an easy-to-use Web application development environment provided with DB2.
• Chapter 9 Perl Programming—Discusses writing Perl scripts to access DB2 databases using the Perl DBI (Database Interface).
• Chapter 10 DB2 Extenders—A 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.

Note

More 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.



Updates

Submit Errata

