Advanced Database Feature Guide


Writing an application

This section introduces a conceptual view of a typical DB2 CLI application.

A DB2 CLI application can be broken down into a set of tasks. Some of these tasks are organized into discrete steps, while others may apply throughout the application.

Tasks described in this section are basic tasks that apply to all applications. More advanced tasks, such as using array insert or using large object support are discussed in the Advanced Features section.

Every DB2 CLI application contains three main tasks:

Initialization
This task allocates and initializes some resources in preparation for the main Transaction Processing task. Refer to "Initialization and Termination" section for details.

Transaction Processing
This is the main task of the application. SQL statements are passed to DB2 CLI to query and modify the data. Refer to the "Transaction Processing" section for details.

Termination
This task frees allocated resources. Refer to "Initialization and Termination" section for details.

As well as the tree tasks listed above, there are general tasks, such as exception handling and retrieval of diagnostic messages, which occur throughout an application.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]