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 (unless the language is not supported for that platform. Please see "Supported Software by Platform" for details).

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

• DB2 embedded SQL for Java (SQLJ) support to develop Java embedded SQL 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 the set of precompiler service APIs, and how to use them, is available from the anonymous FTP site, ftp://ftp.software.ibm.com. The PostScript file, called prepapi.psbin, is located in the directory /ps/products/db2/info. This file is in binary format. If you do not have access to this electronic forum and would like to get a copy of this document, you can call IBM Service as described in the Service Information Flyer.

• SQL92 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 ]