To Next Page

To Previous Page

Table 27. Mappings of Java, JDBC, and SQL data types for calling stored procedures and user-defined

functions (continued)

Java data type JDBC data type SQL data type

java.math.BigDecimal DECIMAL DECIMAL

java.math.BigDecimal java.types.OTHER DECFLOATn

java.math.BigDecimal com.ibm.db2.jcc.DB2Types.DECFLOAT DECFLOATn

java.lang.String CHAR CHAR

java.lang.String CHAR GRAPHIC

java.lang.String VARCHAR VARCHAR

java.lang.String VARCHAR VARGRAPHIC

java.lang.String LONGVARCHAR VARCHAR

java.lang.String VARCHAR CLOB

java.lang.String LONGVARCHAR CLOB

java.lang.String CLOB CLOB

byte[] BINARY CHAR FOR BIT DATA

byte[] VARBINARY VARCHAR FOR BIT

DATA

byte[] BINARY BINARY

byte[] VARBINARY VARBINARY

byte[] LONGVARBINARY VARCHAR FOR BIT

DATA

byte[] VARBINARY BLOB

byte[] LONGVARBINARY BLOB

java.sql.Date DATE DATE

java.sql.Time TIME TIME

java.sql.Timestamp TIMESTAMP TIMESTAMP

java.sql.Blob BLOB BLOB

java.sql.Clob CLOB CLOB

java.sql.Clob CLOB DBCLOB

java.io.ByteArrayInputStream None BLOB

java.io.StringReader None CLOB

java.io.ByteArrayInputStream None CLOB

com.ibm.db2.jcc.DB2RowID

(deprecated)

com.ibm.db2.jcc.DB2Types.ROWID ROWID

java.sql.RowId java.sql.Types.ROWID ROWID

Chapter 7. JDBC and SQLJ reference information 197

|||

Questions and Answers:

Need help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability

IBM DB2 User Manual

Table of Contents

Questions and Answers:

IBM DB2 Specifications