DB2 Universal Database v7.1: Application Development Certification Guide (IBM DB2 Certification Guide Series) - Softcover

Sanyal, Steve; Martineau, David; Gashyna, Kevin; Kyprianou, Michael

Softcover

ISBN 10: 0130913677 ISBN 13: 9780130913678

Publisher: IBM Press, 2000

Synopsis

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

About this title

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

From the Back Cover

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

Edition details

• Publisher: IBM Press
• Publication date: 2000
• Language: English
• ISBN 10: 0130913677
• ISBN 13: 9780130913678
• Binding: Paperback
• Number of pages: 320