DB2 application development overview - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 3

DB2 installation
DB2 V8 Application Development client or DB2 9 Client installation is required
for DB2 application development.
Database application programming interface
The interfaces include CLI/ODBC, embedded SQL, JDBC/SQLJ, OLE DB,
Perl DBI, PHP, and ADO.NET. We discuss these in further detail in the next
section.
Programming language
Supported programming languages for DB2 include C, C++, COBOL,
FORTRAN, Java, Perl, PHP, REXX, and .NET.
Transaction manager and development tools
Keep in mind that using the XA (distributed transaction processing) interface
requires transaction manager.
There are a number of development tools available for DB2 database
application development. We discuss IBM DB2 Development Add-In for
Visual Studio (Visual Studio 2005 Add-In) and the Developer Workbench in
this topic.
1.1.2 DB2 supported interfaces
IBM DB2 provides various programming interfaces for data access. These
interfaces provide functions and methods that you can use to perform various
interactions with the database.
Administrative API
The DB2 Administrative API is primarily used for issuing DB2 administrative
commands. It allows you to develop applications that you can use to administer
and monitor DB2 instances and databases.
All the administrative API functions are derived from DB2 Command Line
Processor (CLP) commands. You can find more information regarding DB2 API
functions in the Administrative API reference , SC10-4231.
Embedded SQL
The SQL statement can be embedded within a host language where SQL
statements provide the database interface while the host programming language
provides all remaining functionality.