IBM DB2 User Manual

Table 74. Support for Statement methods (continued)
JDBC method
IBM Data Server
Driver for JDBC and
SQLJ support
DB2 JDBC Type 2
Driver for Linux, UNIX
and Windows support
IDS JDBC Driver
support
Notes:
1. For the IBM Data Server Driver for JDBC and SQLJ, Statement.cancel() is supported only in the following
environments:
v Type 2 and type 4 connectivity from a Linux, UNIX, or Windows client to a DB2 Database for Linux, UNIX,
and Windows server, Version 8 or later
v Type 2 and type 4 connectivity from a Linux, UNIX, or Windows client to a DB2 for z/OS server, Version 9 or
later
v Type 4 connectivity from a z/OS client to a DB2 Database for Linux, UNIX, and Windows server, Version 8 or
later
v Type 4 connectivity from a z/OS client to a DB2 for z/OS server, Version 9 or later
2. For the DB2 JDBC Type 2 Driver for Linux, UNIX and Windows, Statement.cancel() is supported only in the
following environments:
v Connections to a DB2 Database for Linux, UNIX, and Windows server, Version 8 or later
v Connections to a DB2 for z/OS server, Version 9 or later
3. The DB2 JDBC Type 2 Driver for Linux, UNIX and Windows does not support the JDBC 3.0 form of this method.
4. Not supported for stored procedure ResultSets.
5. For DB2 for i5/OS and for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS, this
method is supported only for a seconds value of 0.
6. For the IBM Data Server Driver for JDBC and SQLJ Version 4.0 and later, Statement.setQueryTimeout is
supported for the following methods:
v Statement.execute
v Statement.executeUpdate
v Statement.executeQuery
Statement.setQueryTimeout is not supported for the Statement.executeBatch method.
7. This is a JDBC 4.0 method.
Table 75. Support for Struct methods
JDBC method
IBM Data Server
Driver for JDBC and
SQLJ support
DB2 JDBC Type 2
Driver for Linux, UNIX
and Windows support
IDS JDBC Driver
support
getSQLTypeName No No No
getAttributes No No No
Table 76. Support for Wrapper methods
JDBC method
1
IBM Data Server
Driver for JDBC and
SQLJ support
DB2 JDBC Type 2
Driver for Linux, UNIX
and Windows support
IDS JDBC Driver
support
isWrapperFor Yes No No
unWrap Yes No No
Notes:
1. These are JDBC 4.0 methods.
Chapter 7. JDBC and SQLJ reference information 279
|
|
|
|
|
|

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