Application Building Guide
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 Software Developer's Kit
(DB2 SDK) for DB2 Universal Database Version 6.1 on the following
platforms:
- AIX
- HP-UX
- Linux
- OS/2
- Silicon Graphics IRIX
- Solaris
- Windows 32-bit operating systems
| Note: | Windows 32-bit operating systems refers to Windows NT, Windows 98, and
Windows 95. Whenever this book mentions Windows 32-bit operating
systems, all three of these operating systems are implied, except in the case
of Systems Network Architecture (SNA) support, REXX suport, or DB2 Connect,
formerly known as Distributed Database Connection Services (DDCS).
These are supported on Windows NT 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).
- 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 Software
Developer's Kit (DB2 SDK) on OS/2 server and client workstations.
- DB2 for UNIX Quick Beginnings, which explains how to install the database manager, and the DB2 Software
Developer's Kit (DB2 SDK) on UNIX server and client workstations.
- DB2 for Windows NT Quick Beginnings, which explains how to install the database manager, and the DB2 Software
Developer's Kit (DB2 SDK) 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, "How the DB2 Library Is Structured".
| 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.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]