Adminstrative

ODBC

CLI

JDBC

SQLJ

Application

Application

Application

Application

Application

Embed. SQL

OLEDB

Perl

Application

Application

Application

OLEDB

JDBC

DB2 APIs

Perl

Driver

Driver

Type

Type

2

3,4

CLI/ODBC

Driver

DB2 Server

Figure 1 11   Application connections to DB2 UDB

DB2 administrative API

DB2 provides numerous administrative APIs, which allow applications perform 

database administration tasks available in DB2 UDB Control Center; for 

example, import and export data, creating, activating, backing up, or restoring a 

database. These calls can be included within embedded SQL and DB2 CLI 

applications. Examples of API programs can be found in the DB2 home directory 

sqllib/sample/

 for different progaramming languages. For additional information 

refer to DB2 

Administrative API Reference

, SC09 4824.

Embedded SQL statements in applications

Two different kind of SQL statements have to be distinguished:

Static SQL statements

With static SQL statements, you know before compile time that the SQL 

statement type and the table and column names. The only unknowns are the 

specific data values the statement is searching for or updating. This values 

can be represented in host language variables.

24 

MySQL to DB2 UDB Conversion Guide