Building Applications for UNIX** Environments

Chapter 1. About the DB2 Software Developer's Kit

The DB2 Software Developer's Kit (DB2 SDK) provides the tools and environment you need to develop applications that access DB2 servers and application servers that implement the Distributed Relational Database Architecture (DRDA).

You can develop applications on a server or client that has the DB2 SDK installed. Your applications can also run on a server or client. To run your applications on a client, you must have the appropriate DB2 Client Application Enabler (DB2 CAE) installed. The DB2 CAE is installed from the DB2 Client Pack. See Chapter 2. "Setup" for information about setting up your programming environment.

The DB2 SDKs for the UNIX platforms described in this book include the following:

• Precompilers for C, C++, COBOL, and FORTRAN.

• Include files and code samples to develop applications that use embedded SQL.

• Programming libraries, include files, and code samples that use the DB2 Call Level Interface (DB2 CLI) to develop applications which are easily ported to ODBC and compiled with an ODBC SDK. The DB2 CAE contains an ODBC driver for DB2 that supports applications developed with Visigenic ODBC version 2.1.

• DB2 Java Database Connectivity (DB2 JDBC) support to develop Java applications and applets.

• On AIX, support to develop database applications that use the REXX language.

• Interactive SQL through the Command Line Processor (CLP) to prototype SQL statements or to perform ad hoc queries against the database.

• A documented API to enable other application development tools to implement precompiler support for DB2 directly within their products. For example, on AIX, IBM COBOL and PL/I use this interface. Information on documented APIs can be obtained by downloading either of the following files. On Compuserve, the file is located in the IBM DB2 Family Forum on CompuServe (GO IBMDB2). Once in this forum, get the file called PREPAPI.TXT from Library 1. This file must be downloaded in ASCII format. On the Internet, go to the anonymous FTP site ps.boulder.ibm.com. The file is called prepapi.txt, and is located in the directory /ps/products/db2/info. This file is in ASCII format. Refer to the DB2 Solutions Directory for other examples of IBM and third party providers. You can get the Directory from CompuServe in the IBMDB2 forum, or contact your IBM representative for a copy.

• SQL 92 and MVS Conformance Flagger: Identifies embedded SQL statements in applications that do not conform to the ISO/ANSI SQL92 Entry Level standard, or which are not supported by DB2 for MVS. If you migrate applications developed on a workstation to another platform, the Flagger saves you time by showing syntax incompatibilities. Refer to the Command Reference for information about the SQLFLAG option in the PRECOMPILE PROGRAM command.

[ DB2 List of Books | Search the DB2 Books ]