Db2 Application Development

Application Design

Application Design

Some basic principles for designing applications within Db2.

Development Environment

The Db2 database application development environment

The Db2 database application development environment is composed of several software elements.

Configuring the database application development environment

To configure the database application development environment, you must configure the operating system, Data Server Client, development environment, and transaction manager.

Support for elements of the database application development environment

Application development for Db2 databases is supported for a wide range of operating systems and database clients, along with numerous programming interfaces, languages, compilers, and tools.

Supported database APIs

ADO.NET

In recent years, Microsoft has been promoting a new software development platform for Windows, known as the .NET Framework. The .NET Framework is Microsoft's replacement for Component Object Model (COM) technology.

IBM OLE DB Provider for Db2

The IBM® OLE DB Provider for Db2 allows Db2 to act as a resource manager for the OLE DB provider. This support gives OLE DB-based applications the ability to extract or query Db2 data using the OLE interface.

Db2 Call Level Interface and ODBC

Db2 Call Level Interface (CLI) is IBM's callable SQL interface to the Db2 family of database servers. It is a 'C' and 'C++' application programming interface for relational database access that uses function calls to pass dynamic SQL statements as function arguments.

DB2CI

DB2CI is a callable SQL interface to the Db2® database servers. It is a 'C' and 'C++' application programming interface for Db2 database access that uses function calls to connect to databases, manage cursors, and perform SQL statements.

Embedded SQL

Embedded SQL applications connect to databases and execute embedded SQL statements. The embedded SQL statements are contained in a package that must be bound to the target database server.

Java

The Db2® and IBM® Informix® database systems provide driver support for client applications and applets that are written in Java.

JSON

JSON provides a flexible mechanism to store and transmit data between application tiers. Db2® provides the ability to work directly with JSON from both the client and through SQL.

Node.js

Node.js is a software platform that is built on JavaScript. Node.js provides a fast, scalable, lightweight application solution for data-intensive real-time applications.

Perl

Perl database Interface (DBI) is an open standard application programming interface (API) that provides database access for client applications that are written in Perl. Perl DBI defines a set of functions, variables, and conventions that provide a platform-independent database interface.

PHP

PHP: Hypertext Preprocessor (PHP) is an interpreted programming language that is widely used for developing web applications.

Python

Python is a general purpose, high-level scripting language that is well suited for rapid application development. Python emphasizes code readability and supports various programming paradigms, including procedural, object-oriented, aspect-oriented, meta, and functional programming.

Ruby on Rails

Collectively known as the IBM_DB gem, the IBM_DB Ruby driver, and Rails adapter allows Ruby applications to access the IBM® database servers.