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