Application Building Guide

DB2 Call Level Interface (CLI) Applications

The DB2 SDK comes with sample programs that use DB2 Call Level Interface (DB2 CLI) function calls. You can study the samples to learn how to access DB2 databases using these function calls in your applications.

The sample programs, the build files, and a makefile, are contained in the directory sqllib/samples/cli on UNIX, or %DB2PATH%\samples\cli on OS/2 and Windows 32-bit operating systems. You may need to modify the compiler options in the build files and the makefile for your environment.

The following are the sample programs used in this book to demonstrate the steps for building and running DB2 CLI applications (the steps you follow may vary, depending on your environment):

basiccon

establishes a basic connection with the database.

outcli2

is the client program of a client/server example; the server program is outsrv2.

outsrv2

is the server program of a client/server example; the client program is outcli2.

calludf

uses the functions created by the user-defined function program, udf .

For a more detailed description of all the DB2 CLI sample programs, see Table 8. The CLI Guide and Reference explains how the samples using DB2 CLI work.

The following list points you to where you can find building information for the DB2 CLI applications and stored procedures for the supported platform C compilers:

AIX IBM C

"DB2 CLI Applications" and "DB2 CLI Stored Procedures".

AIX IBM VisualAge C++

"DB2 CLI Applications" and "DB2 CLI Stored Procedures".

HP-UX C

"DB2 CLI Applications" and "DB2 CLI Stored Procedures"

GNU/Linux gcc

"DB2 CLI Applications" and "DB2 CLI Stored Procedures"

OS/2 IBM VisualAge Version 3 for C++

"DB2 CLI Applications" and "DB2 CLI Stored Procedures"

OS/2 IBM VisualAge Version 4 for C++

"DB2 CLI Applications" and "DB2 CLI Stored Procedures".

Silicon Graphics IRIX MIPSpro C

"DB2 CLI Applications"

Solaris SPARCompiler C and IBM C

"DB2 CLI Applications" and "DB2 CLI Stored Procedures"

Windows 32-bit Operating Systems Microsoft Visual C++

"DB2 CLI Applications" and "DB2 CLI Stored Procedures"

Windows 32-bit Operating Systems IBM VisualAge for C++ Version 3.5

"DB2 CLI Applications" and "DB2 CLI Stored Procedures"

Windows 32-bit Operating Systems IBM VisualAge for C++ Version 4.0

"DB2 CLI Applications" and "DB2 CLI Stored Procedures".

[ DB2 List of Books | Search the DB2 Books ]