Ships from: Chatham, NJ
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
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:
Whatever your DB2 application, whatever your environment — UNIX, Windows, or OS/2 — this is the most thorough, authoritative development guide you can find.
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).
This will be a required book for the DB2 Certification exam.
All applications communicate with DB2 in a client/server environment using the Struc-tured Query Language (SQL) within the context of one or more programming interfaces such as embedded SQL, JDBC, and the Perl DBI (Database Interface). Different interfaces also provide additional features that you may find useful. This is why it is important to understand the options available to you as an application developer.
In this chapter, we introduce fundamental DB2 concepts and describe how applications connect to DB2 and use SQL statements to access and modify data in a DB2 UDB database. We assume that you already know about database objects such as tables and indexes, and that you are also familiar with SQL from the companion to this guide, The DB2 V7.1 Administration Certification Guide. We still cover each of these topics briefly within this chapter to ensure you have an understanding of them for the purposes of the certification exam.
You can find a complete reference for SQL and DB2 database objects in the SQL Reference, which is included among the DB2 online books. The SQL Getting Started guide is another online book that includes a good tutorial on SQL. If you require information about installing DB2, please refer to the DB2 Quick Beginnings books applicable to your environment, or read Chapter 2 of The DB2 V7.1 Administration Certification Guide.
If your server instance has remote client functionality, you can also configure one or more network protocol listeners for the instance to accept incoming database requests from remote clients. Each server instance on a system must have a unique protocol listener. For example, if you have two server instances on your Windows NT system and you want them to be accessible to remote TCP/IP clients, you must configure each to listen on a unique TCP/IP service or port.
If an application connects to a database within the same instance from which it runs, the application is known as a local client. In this case, there is no need to install an additional DB2 Runtime Client since this component is also included within the libraries of the DB2 server instance. On the other hand, if the application is installed on a system other than the DB2 UDB server, or run on a different instance on the same system, the application is known as a remote client. The DB2 Runtime Client component must be installed on each remote workstation or system executing the application.
In some cases, you may have installed a DB2 server product on one platform and will be running an application on a different platform. For example, you may have DB2 UDB V7.1 EE installed on AIX, but your SQLj applications will run on Windows NT. In this case, you will need to obtain a DB2 UDB AD client for Windows NT. When you install any DB2 UDB client on a Windows 95/98/NT workstation, a client instance called "DB2" will be automatically...
| Foreword | ||
| Preface | ||
| Ch. 1 | Introduction to Database Applications for DB2 | 1 |
| Ch. 2 | DB2 Programming Roadmap | 19 |
| Ch. 3 | DB2 Programming Features and Strategies | 27 |
| Ch. 4 | Embedded SQL Programming | 57 |
| Ch. 5 | Administrative APIs | 105 |
| Ch. 6 | CLI/ODBC and OLE DB Programming | 115 |
| Ch. 7 | Java Programming | 155 |
| Ch. 8 | Net.Data | 197 |
| Ch. 9 | Perl Programming | 215 |
| Ch. 10 | DB2 Extenders | 225 |
| App. A | DB2 UDB Application Development Test Objectives | 243 |
| App. B | DB2 UDB Application Development Sample Exam | 247 |
| App. C | DB2MALL Database | 265 |
| App. D | Application Troubleshooting | 271 |
| Index | 279 |
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).
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:
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.
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.
http://www.ibm.com/certify.
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:
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.
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.
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.
Here are several resources on the Internet that are invaluable for DB2 documentation and product support:
http://www.software.ibm.com/data/db2http://www.software.ibm.com/data/db2/libraryhttp://www.idug.orghttp://www.db2mag.comftp://ftp.software.ibm.com/ps/products/db2/fixesftp://ftp.software.ibm.com/ps/products/db2/toolsftp://ftp.software.ibm.com/ps/products/db2extenders/fixes/news.software.ibm.comibm.software.db2.scholarsibm.software.db2.udb.eeeibm.software.db2.udb.windows2000comp.databases.ibm-db2The 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.
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.
Overview