IBM GC09-2830-00 Server User Manual


 
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