Application Building Guide

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 build and run DB2 applications with a DB2 SDK installed. You can run DB2 applications on these DB2 clients:

• DB2 Run-Time Client

• DB2 Administration Client

See Chapter 2, "Setup" for information about setting up your programming environment.

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

• Precompilers for C/C++, Java, COBOL, and Fortran (providing the language is 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, which is available from Microsoft for Windows 32-bit operating systems, and from various other vendors for many of the other supported platforms. For Windows 32-bit operating systems, DB2 clients contain an ODBC driver that supports applications developed with the Microsoft ODBC Software Developer's Kit. For all other platforms, DB2 clients contain an optionally installed ODBC driver that supports applications that can be developed with an ODBC SDK for that platform, if one exists.

• DB2 Java Enablement, which includes DB2 Java Database Connectivity (DB2 JDBC) support to develop Java applications and applets, and DB2 embedded SQL for Java (DB2 SQLJ) support to develop Java embedded SQL applications and applets.

• On Windows 32-bit operating systems, Java Development Kit (JDK) 1.1.7 and Java Runtime Environment (JRE) 1.1.7 for Win32 from IBM.

• On AIX, OS/2, and Windows 32-bit operating systems, support to develop database applications that use the REXX language.

• On Windows 32-bit operating systems, code samples with ActiveX Data Objects (ADO), and Object Linking and Embedding (OLE) automation UDFs, implemented in Microsoft Visual Basic and Microsoft Visual C++. Also, code samples with Remote Data Objects (RDO) implemented in Microsoft Visual Basic.

• On Windows 32-bit operating systems, Object Linking and Embedding Database (OLE DB) table functions.

• DB2 Stored Procedure Builder (SPB), a GUI-based tool that supports the rapid development of DB2 stored procedures. It provides a single development environment for the DB2 family ranging from workstation to OS/390. It can be launched from these popular application development tools: Microsoft Visual Studio, Microsoft Visual Basic, and IBM Visual Age for Java, or launched as a separate application from the IBM DB2 Universal Database program group.

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

• A set of documented APIs to enable other application development tools to implement precompiler support for DB2 directly within their products. For example, on AIX and OS/2, 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.

• An SQL92 and MVS Conformance Flagger, which 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 OS/390. 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 ]