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