Application Building Guide

About the DB2 Application Development Client

The DB2 Application Development (DB2 AD) Client 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 AD Client installed. You can also run DB2 applications on these DB2 clients:

• DB2 Run-Time Client
• DB2 Administration Client

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

The DB2 AD Clients 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).
• Embedded SQL application support, including programming libraries, include files and code samples.
• DB2 Call Level Interface (DB2 CLI) application support, including programming libraries, include files, and code samples to develop applications which are easily ported to ODBC and compiled with an ODBC SDK. An ODBC SDK 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. Only DB2 Clients for Windows 32-bit operating systems contain an ODBC driver manager.
• 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.
• Java Development Kit (JDK) 1.1.8 and Java Runtime Environment (JRE) 1.1.8 from IBM, installed with DB2 for AIX and DB2 for Windows 32-bit operating systems, and shipped with DB2 for OS/2.
• REXX language support on AIX (32-bit applications only), OS/2, and Windows 32-bit operating systems. This support is not updated beyond DB2 Version 5.2.
• ActiveX Data Objects (ADO) and Object Linking and Embedding (OLE) automation UDFs and Stored Procedures on Windows 32-bit operating systems, including code samples implemented in Microsoft Visual Basic and Microsoft Visual C++. Also, code samples with Remote Data Objects (RDO) implemented in Microsoft Visual Basic.
• Object Linking and Embedding Database (OLE DB) table functions on Windows 32-bit operating systems.
• DB2 Stored Procedure Builder (SPB), available on AIX, Solaris, and Windows 32-bit operating systems. This is 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. On Windows, it can be launched from these popular application development tools: Microsoft Visual Studio, Microsoft Visual Basic, and IBM VisualAge for Java, or launched as a separate application from the IBM DB2 Universal Database program group. On AIX and Solaris, it can be started with the db2spb command.
• Interactive SQL through the Command Center or 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 uses this interface. Information on the set of Precompiler Services APIs 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 order it from 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.