Figure 7 5   DB2 Query processing

DB2 CLI query processing involves the following steps:

a. Allocating statement handle

A statement handle tracks execution of the query for a particular 

connection. This can be allocated using

SQLAllocHandle()

 with a 

HandleType of 

SQL_HANDLE_STMT

.

b. Preparing and executing SQL statements 

DB2 UDB provides two ways for preparing and executing the query:

  Prepare and execute as separate steps

If you plan to execute the same query multiple times with different 

parameters, you can use this technique. This involves the following 

steps: Preparation of query using 

SQLPrepare()

, binding of the 

206 

MySQL to DB2 UDB Conversion Guide