IBM DB2 User Manual

Table 28. Mappings of SQL data types in a CREATE PROCEDURE or CREATE FUNCTION statement to data types in
the corresponding Java stored procedure or user-defined function program (continued)
SQL data type in CREATE PROCEDURE or CREATE
FUNCTION
1
Data type in Java stored procedure or
user-defined function method
2
DATE java.sql.Date
TIME java.sql.Time
TIMESTAMP java.sql.Timestamp
BLOB java.sql.Blob
CLOB java.sql.Clob
DBCLOB java.sql.Clob
ROWID java.sql.Types.ROWID
Notes:
1. A DB2 for z/OS stored procedure or user-defined function parameter cannot have the XML data type.
2. For a stored procedure or user-defined function on a DB2 Database for Linux, UNIX, and Windows server, only
the first data type is valid.
3. DECFLOAT parameters in Java routines are valid only for connections to DB2 Version 9.1 for z/OS or later
database servers. DECFLOAT parameters in Java routines are not supported for connections to for Linux, UNIX,
and Windows or DB2 for i. Use of DECFLOAT requires the SDK for Java Version 5 (1.5) or later.
4. BIGINT, BINARY, and VARBINARY are valid for connections to DB2 Version 9.1 for z/OS or later database
servers or DB2 V9.1 for Linux, UNIX, and Windows or later database servers.
Related concepts
“Variables in JDBC applications” on page 23
“Java data types for retrieving or updating LOB column data in JDBC
applications” on page 53
“ROWIDs in JDBC with the IBM Data Server Driver for JDBC and SQLJ” on
page 55
“Distinct types in JDBC applications” on page 56
“Savepoints in JDBC applications” on page 57
“XML data in JDBC applications” on page 65
“XML column updates in JDBC applications” on page 65
“XML data retrieval in JDBC applications” on page 67
“Variables in SQLJ applications” on page 110
“LOBs in SQLJ applications with the IBM Data Server Driver for JDBC and
SQLJ” on page 136
“Java data types for retrieving or updating LOB column data in SQLJ
applications” on page 137
“ROWIDs in SQLJ with the IBM Data Server Driver for JDBC and SQLJ” on
page 143
“Distinct types in SQLJ applications” on page 144
“Differences between Java routines and other routines” on page 176
Related reference
“JDBC differences between the current IBM Data Server Driver for JDBC and
SQLJ and earlier DB2 JDBC drivers” on page 370
Chapter 7. JDBC and SQLJ reference information 199
|
|
|

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