Building Applications for UNIX** Environments

About This Book

This book explains how to build applications using the DB2 Software Developer's Kits (DB2 SDKs) for DB2 Universal Database Version 5.2 on the following UNIX operating systems:

• AIX
• HP-UX
• SCO UnixWare 7
• Silicon Graphics IRIX
• Solaris

The book provides information to set up your environment for developing DB2 applications, and step-by-step instructions to compile, link, and run these applications in this environment.

Different programming interfaces can be used to develop your applications:

Embedded SQL

Uses SQL statements that are precompiled before your program is compiled.

DB2 Call Level Interface (CLI)

Is a callable SQL interface based on the X/Open CLI specification, and is compatible with Microsoft Corporation's Open Database Connectivity (ODBC) interface.

Java Database Connectivity (JDBC)

Is a dynamic SQL API for Java. The JDBC API is included in the Java Development Kits available for supported platforms.

DB2 Application Programming Interfaces (APIs)

Use administrative functions in your applications to create administrative programs to manage DB2 databases.

For information on these programming interfaces, and to decide which one best fits your needs, refer to the Road Map to DB2 Programming, especially chapter 2, "Deciding which Programming Interface to Use".

For more detailed information on each of the different programming interfaces, refer to:

• Embedded SQL Programming Guide

  Discusses how to code and design application programs that access DB2 family servers using embedded SQL and Java Database Connectivity (JDBC).

• CLI Guide and Reference

  Explains how to code and design application programs that use the DB2 Call Level Interface and ODBC.

• API Reference

  Discusses how to code and design application programs that use DB2 Application Programming Interfaces.

You will find the following books useful for further related information, such as detailed product installation and setup:

• Quick Beginnings for UNIX

  Explains how to install the database manager, and the DB2 Software Developer's Kit (DB2 SDK) on server and client workstations.

• Command Reference

  Explains how to use the DB2 Command Line Processor (CLP).

• Troubleshooting Guide

  Helps you resolve application development problems involving DB2 clients and servers, as well as problems with related tasks in database administration and connectivity.

Important new information for those of the above books not re-issued since the release of DB2 Universal Database Version 5 is documented in What's New. This includes information for the Embedded SQL Programming Guide and the CLI Guide and Reference. For a complete list of the DB2 documentation library, see Appendix D. "How the DB2 Library Is Structured".

Notes:

1. The examples in this book are provided "as is" without any warranty of any kind. The user, and not IBM, assumes the entire risk of quality, performance, and repair of any defects.

2. A revision bar, "|", on the left side of a page indicates that the line on the same level has been modified or added since the book was last issued with the release of DB2 Universal Database Version 5.

[ DB2 List of Books | Search the DB2 Books ]