BN.com Gift Guide

DB2 Universal Database v7.1: Application Development Certification Guide

Overview

  • 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, ...
See more details below
Available through our Marketplace sellers.
Other sellers (Multimedia Set)
  • All (11) from $1.99   
  • New (4) from $31.50   
  • Used (7) from $1.99   
Close
Sort by
Page 1 of 1
Showing 1 – 3 of 4
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$31.50
Seller since 2014

Feedback rating:

(310)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$35.12
Seller since 2008

Feedback rating:

(172)

Condition: New
0130913677 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$60.00
Seller since 2014

Feedback rating:

(193)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing 1 – 3 of 4
Close
Sort by
Sending request ...

Overview

  • 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).

This will be a required book for the DB2 Certification exam.

Read More Show Less

Editorial Reviews

Booknews
A group of IBM experts presents the skills and techniques needed to build enterprise, Web, and e-business applications with DB2 UDB V7.1 and gain the IBM Certified Solutions Expert certification for DB2 application development. CD-ROM includes a library of programming exercises, 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 version). Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780130913678
  • Publisher: Pearson Education
  • Publication date: 12/1/2000
  • Series: IBM DB2 Series
  • Edition description: BK&CD-ROM
  • Pages: 320
  • Product dimensions: 6.96 (w) x 9.32 (h) x 0.98 (d)

Meet the Author

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.

Read More Show Less

Read an Excerpt

Chapter 1: Introduction to Database Applications for DB2

The relational database of choice for modern distributed applications is IBM's widely popular DB2 Universal Database (UDB). DB2 UDB V7.1 provides high-performance data access, reliability, and an abundance of advanced features. Whether your application is an e-commerce site on the Web or a directory service such as a Lightweight Directory Access Protocol (LDAP) server, the overall concepts for all database applications remain the same. Data-base applications mostly perform two major tasks, and are categorized as such. Applications that modify the contents of databases and perform transaction processing are known as Online Trans-action Processing (OLTP) applications. Applications that perform ad hoc queries to analyze the contents of databases are known as Decision Support Systems (DSS), or Online Analytical Processing (OLAP) applications.

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.

1.1 Objectives

In each chapter, we will begin with a set of goals for the reader. These goals will describe the concepts you should be familiar with after reading the chapter and completing the exercises. After reading the first chapter, you should have a general understanding of:
  • The DB2 UDB client server environment.
  • Database objects that will be relevant to you as an application developer.
  • How SQL is used to interact with DB2 databases.
  • The common programming structure of all database applications.
We begin by giving you an understanding of how DB2 UDB V7.1 is organized.

1.2 DB2 UDB Server Instances and Databases

A database is simply an organized collection of related data. High-end Relational Database Management Systems (RDBMS) such as DB2 UDB provide an encapsulated client server environment where a persistent database server process serves requests from external client applications. Every DB2 instance is an RDBMS engine process that is uniquely named on a particular system. A DB2 database is created within the context of a specific DB2 instance. To create a DB2 database, you need to install a DB2 UDB V7.1 server product. The DB2 UDB V7.1 product packages are as follows:
  • Satellite Edition (SE) – A special RDBMS engine with a small footprint that is intended for occasionally connected systems. It will not accept incoming database requests from remote clients.
  • Personal Edition (PE) – An RDBMS engine that will not accept incoming remote database requests. Available on Windows NT, Linux, and OS/2 only.
  • Workgroup Edition (WE) – An RDBMS engine that will accept incoming database requests from remote clients. Available on Windows NT, Linux, and OS/2 only.
  • Enterprise Edition (EE) – Similar to Workgroup Edition, but also allows remote and local clients to access data on a host database such as DB2/390 or DB2/400.
  • Enterprise Extended Edition (EEE) – Similar to Enterprise Edition, with additional support for clusters of database servers in a partitioned database environment. Available on AIX, Windows NT, Solaris, and HP-UX.
Using any of these products, you can create one or more DB2 server instances. Every instance has a name unique to the system on which it is installed, and this name is specified when creating the instance. Each DB2 server instance is a separate DBMS (Database Management System) process within whose context you can create and manage one or more DB2 databases. Every instance can also be configured with regard to memory usage and other parameters in the database manager configuration and DB2 profile registry.

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.

1.2.1 DB2 UDB Client Instances

Each DB2 UDB V7.1 product package installation also includes three common client components:
  • DB2 Runtime Client – Includes DB2 runtime libraries that allow applications to access local and remote DB2 databases.
  • DB2 Administration Client – Similar to the Runtime Client, but also provides graphical DB2 UDB administration tools, as well as additional utilities and DB2 bind files.
  • DB2 Application Development (AD) Client – Similar to the Administration Client, but provides DB2 developer tools such as the Stored Procedure Builder (SPB), program precompilers, static libraries, and numerous samples.
Figure 1-1 shows the various DB2 client and server components and their hierarchical nature. By viewing this diagram, you should be aware that DB2 client components are also present in each DB2 server instance. Thus, when we use the term "DB2 client," we may be referring to either a client-only install or the client component on a DB2 server. You can deter-mine which we are referring to based on the following definitions. All DB2 clients are freely downloadable from the official DB2 Web site.

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

Read More Show Less

Table of Contents

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
Read More Show Less

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)