EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #283 background imageLoading...
Page #283 background image
Table 51. Support for PreparedStatement 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. If the value of the length parameter is -1, all of the data from the InputStream or Reader is read and sent to the
data source.
2. Supported forms of this method include the following JDBC 4.0 forms:
setAsciiStream(int parameterIndex, InputStream x, long length)
setAsciiStream(int parameterIndex, InputStream x)
3. Supported forms of this method include the following JDBC 4.0 forms:
setBinaryStream(int parameterIndex, InputStream x, long length)
setBinaryStream(int parameterIndex, InputStream x)
4. Supported forms of this method include the following JDBC 4.0 form:
setBlob(int parameterIndex, InputStream inputStream, long length)
5. Supported forms of this method include the following JDBC 4.0 forms:
setCharacterStream(int parameterIndex, Reader reader, long length)
setCharacterStream(int parameterIndex, Reader reader)
6. Supported forms of this method include the following JDBC 4.0 form:
setClob(int parameterIndex, Reader reader, long length)
7. This is a JDBC 4.0 method.
8. The database server does no timezone adjustment for datetime values. The JDBC driver adjusts a value for the
local timezone before sending the value to the server if you specify a form of the setDate, setTime, or
setTimestamp method that includes a java.util.Calendar parameter.
9. The following form of setNull is not supported:
setNull(int parameterIndex, int jdbcType, String typeName)
10. setString is not supported if the column has the FOR BIT DATA attribute or the data type is BLOB.
Table 52. Support for Ref 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
get BaseTypeName No No No
Table 53. Support for ResultSet 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
absolute Yes Yes Yes
afterLast Yes Yes Yes
beforeFirst Yes Yes Yes
cancelRowUpdates Yes No No
clearWarnings Yes Yes Yes
close Yes Yes Yes
deleteRow Yes No No
findColumn Yes Yes Yes
first Yes Yes Yes
getArray No No No
Chapter 7. JDBC and SQLJ reference information 267

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

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

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability