Running your own applications – IBM GC09-2830-00 User Manual

Page 31

Advertising
background image

Through a DB2 client, these applications can access all servers and, by using
the DB2 Connect product (or the DB2 Connect functionality supplied with
DB2 Enterprise - Extended or DB2 Enterprise Edition), they can also access
DB2 Universal Database for AS/400, DB2 Universal Database for OS/390, and
DB2 for VSE & VM database servers.

The DB2 Software Developer’s Kit allows you to develop applications that use
the following interfaces:
v Embedded SQL
v Call Level Interface (CLI) development environment (which is compatible

with ODBC from Microsoft)

v Java Database Connectivity (JDBC)
v Embedded SQL for Java (SQLJ)
v DB2 Application Programming Interfaces (APIs) that use administrative

functions to manage a DB2 database.

The DB2 Software Developer’s Kit includes:
v Precompilers for Java, C, C++, COBOL, and FORTRAN.
v Libraries, include files, and code samples to develop applications that use

SQLJ and DB2 CLI.

v JDBC and SQLJ support to develop Java applications and applets.
v Interactive SQL, through the CLP, to prototype SQL statements and perform

ad-hoc database queries.

v An API to enable other application development tools to implement

precompiler support for DB2 directly with their products.

v An SQL92 and MVS Conformance Flagger to identify embedded SQL

statements in applications not conforming to the ISO/ANSO SQL92 Entry
Level standard, or which are not supported by DB2 for OS/390.

For complete information on the functionality of the Software Developer’s Kit,
and instructions on how to use them, as well as a full list of supported
compilers for your platform, refer to the Application Building Guide.

Running Your Own Applications

Various types of applications can access DB2 databases:
v Applications developed using a DB2 Software Developer’s Kit that include

embedded SQL (including Java SQLJ applications and applets), APIs, stored
procedures, user-defined functions, calls to DB2 CLI, or calls to JDBC
applications and applets.

v ODBC applications such as Lotus Approach, Microsoft Visual Basic,

PowerSoft PowerBuilder, Borland Delphi and thousands more.

Chapter 1. About DB2 Connect

19

Advertising