Adminstrative
ODBC
CLI
JDBC
SQLJ
Application
Application
Application
Application
Application
Embed. SQL
OLEDB
Perl
Application
Application
Application
OLEDB
JDBC
DB2 APIs
Perl
Driver
Driver
Type
Type
2
3,4
CLI/ODBC
Driver
DB2 Server
Figure 1 11   Application connections to DB2 UDB
DB2 administrative API
DB2 provides numerous administrative APIs, which allow applications perform 
database administration tasks available in DB2 UDB Control Center; for 
example, import and export data, creating, activating, backing up, or restoring a 
database. These calls can be included within embedded SQL and DB2 CLI 
applications. Examples of API programs can be found in the DB2 home directory 
sqllib/sample/
 for different progaramming languages. For additional information 
refer to DB2 
Administrative API Reference
, SC09 4824.
Embedded SQL statements in applications
Two different kind of SQL statements have to be distinguished:
Static SQL statements
With static SQL statements, you know before compile time that the SQL 
statement type and the table and column names. The only unknowns are the 
specific data values the statement is searching for or updating. This values 
can be represented in host language variables.
24 
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