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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved