Application Building Guide

Introduction

This book provides the information you need to set up your environment for developing DB2 applications, and provides step-by-step instructions to compile, link, and run these applications in this environment. It explains how to build applications using the DB2 Application Development (DB2 AD) Client for DB2 Universal Database Version 7.1 on the following platforms:

• AIX
• HP-UX
• Linux
• OS/2
• PTX
• Silicon Graphics IRIX
• Solaris Operating Environment
• Windows 32-bit operating systems

Notes:

1. DB2 for NUMA-Q supports the PTX operating system.

2. Windows 32-bit operating systems includes Windows NT, Windows 95, Windows 98, and Windows 2000. Whenever this book mentions Windows 32-bit operating systems, all of these operating systems are implied, except in the case of Systems Network Architecture (SNA) support, and REXX support. These are supported on Windows NT and Windows 2000 only.

To develop your applications, you can use the following programming interfaces:

DB2 Application Programming Interfaces (DB2 APIs)

provide administrative functions to manage DB2 databases.

DB2 Call Level Interface (DB2 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.

Embedded SQL

uses SQL statements coded directly in your program which must be precompiled in order to be converted into run-time function calls.

Embedded SQL for Java (SQLJ)

uses SQL statements in a generated profile that are precompiled and customized into run-time function calls, which in turn provide an interface to the database manager.

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.

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

• The Application Development Guide, which discusses how to code and design application programs that access DB2 family servers using embedded SQL, embedded SQL for Java, and Java Database Connectivity (JDBC). It also discusses user-defined functions (UDFs).
• The CLI Guide and Reference, which explains how to code and design application programs that use the DB2 Call Level Interface and ODBC.
• The Administrative API Reference, which discusses how to code and design application programs that use DB2 Application Programming Interfaces.

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

• DB2 for OS/2 Quick Beginnings, which explains how to install the database manager, and the DB2 Application Development Client on OS/2 server and client workstations.
• DB2 for UNIX Quick Beginnings, which explains how to install the database manager, and the DB2 Application Development Client on UNIX server and client workstations.
• DB2 for Windows Quick Beginnings, which explains how to install the database manager, and the DB2 Application Development Client on server and client workstations for Windows 32-bit operating systems.
• The Command Reference, which explains how to use the DB2 Command Line Processor (CLP), and all non-SQL DB2 commands.
• The Troubleshooting Guide, which helps you resolve application development problems involving DB2 clients and servers, as well as problems with related tasks in database administration and connectivity.

For a complete list of the DB2 documentation library, see Appendix D, "Using the DB2 Library".

Note:

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.

Note:

Links are provided to the source code of some (but not all) of the sample programs presented in this book.