Conceptual view of a DB2 ODBC application

A typical DB2® ODBC application includes initialization, transaction processing, and termination tasks.

You can consider a DB2 ODBC application as a set of tasks. Some of these tasks consist of discrete steps, while others might apply throughout the application. One or more DB2 ODBC functions carry out each of these core tasks.

Every DB2 ODBC application performs three core tasks: initialization, transaction processing, and termination. The following figure illustrates an ODBC application in terms of these tasks.

Figure 1. Conceptual view of a DB2 ODBC application
Begin figure summary. This figure depicts a simple flowchart that shows the flow of an ODBC application from one core task to another. Detailed description available.
Initialization
This task allocates and initializes some resources in preparation for the transaction processing task.
Transaction processing
This task provides functionality to the application. It passes SQL statements to DB2 ODBC that query and modify data.
Termination
This task frees allocated resources. The resources generally consist of data areas identified by unique handles.

In addition to the three tasks listed above, general tasks, such as handling diagnostic messages, occur throughout an application.