DB2 UDB data type
Java type
 Data type description
DATE
java.sql.Date
10 byte character string
TIME
java.sql.Time
8 byte character string
TIMESTAMP
java.sql.Timestamp
26 byte character string
JDBC methods conversion
Some of the methods specified by JDBC specification are not implemented in 
MySQL, so the functionality of these methods would have been implemented  by 
you in your application code. Now you can use those methods with DB2 UDB. 
Some of these methods are listed here:
Blob.truncate()
PreparedStatement.setArray(int, Array)
PreparedStatement.setRef()
PreparedStatement.getParameterMetaData()
ResultSet.getArray(int)
ResultSet.getArray(colName)
ResultSet.getRef(int)
ResultSet.getRef(String)
ResultSet.rowDeleted()
ResultSet.rowInserted()
ResultSet.rowUpdated()
ResultSet.updateArray(int, Array)
ResultSet.updateArray(String, Array)
ResultSet.updateRef(int, Ref)
ResultSet.updateRef(String, Ref)
7.2.4  Converting MySQL C/C++ applications to DB2 UDB
DB2 UDB provides the following programming interfaces for developing an 
application in C/C++:
Embedded SQL
DB2 Call Level Interface (CLI)
Apart from this, DB2 UDB uses C/C++ for server side programming for creating:
Stored procedures on DB2 server
User defined functions (UDF) on DB2 server.
DB2 UDB provides precompilers for C, C++, COBOL, Fortran, REXX, and Java 
to support embedded SQL applications. Embedded SQL applications support 
both static and dynamic SQL statements. Static SQL statements require 
information of all the SQL statements, tables, and data types used at compile 
 Chapter 7. Application porting 
199






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