Table 38. Support for CallableStatement 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
setShort Yes
7
No Yes
setString Yes
7
No Yes
setTime Yes
7
No Yes
setTimestamp Yes
7
No Yes
setURL Yes No No
wasNull Yes Yes Yes
Notes:
1. The inherited getParameterMetaData method is not supported if the data source is DB2 for z/OS.
2. This is a JDBC 4.0 method.
3. The following forms of CallableStatement.getXXX methods are not supported if the data source is DB2 for z/OS:
getXXX(String parameterName)
4. The database server does no timezone adjustment for datetime values. The JDBC driver adjusts a value for the
local timezone after retrieving the value from the server if you specify a form of the getDate, getTime, or
getTimestamp method that includes a java.util.Calendar parameter.
5. The following form of the getObject method is not supported:
getObject(int parameterIndex, java.util.Map map)
6. The following form of the registerOutParameter method is not supported:
registerOutParameter(int parameterIndex, int jdbcType, String typeName)
7. Not supported if the data source is DB2 for z/OS.
8. The following form of setNull is not supported:
setNull(int parameterIndex, int jdbcType, String typeName)
Table 39. Support for Clob 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
free
1
Yes No No
getAsciiStream Yes Yes Yes
getCharacterStream Yes2 on page 256 Yes Yes
getSubString Yes Yes Yes
length Yes Yes Yes
position Yes Yes Yes
setAsciiStream
3
Yes No Yes
setCharacterStream
3
Yes No Yes
setString
3
Yes No Yes
truncate
3
Yes No Yes
Chapter 7. JDBC and SQLJ reference information 255
To Next Page
Loading...
Need help?
General