The com.ibm.db2.jcc.DB2CallableStatement interface extends the java.sql.CallableStatement and the com.ibm.db2.jcc.DB2PreparedStatement interfaces.
The following methods are defined only for the IBM® Data Server Driver for JDBC and SQLJ.
public DBTimestamp getDBTimestamp(int parameterIndex)
throws SQLException
public DBTimestamp getDBTimestamp(String parameterName)
throws SQLException
Returns the value of a TIMESTAMP OUT or INOUT parameter as a DBTimestamp object. If the value of the parameter is NULL, the returned value is null.
This method is not supported for connections to IBM Informix®.
public java.sql.Array getJccArrayAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves an ARRAY value that is designated by a named parameter marker as a java.sql.Array value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.math.BigDecimal getJccBigDecimalAtName(String parameterMarkerName)
throws java.sql.SQLException
public java.math.BigDecimal getJccBigDecimalAtName(String parameterMarkerName,
int scale)
throws java.sql.SQLException
Retrieves a DECIMAL value that is designated by a named parameter marker as a java.math.BigDecimal value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.Blob getJccBlobAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a BLOB value that is designated by a named parameter marker as a java.sql.Blob value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public boolean getJccBooleanAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a BIT or BOOLEAN value that is designated by a named parameter marker as a boolean value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public byte getJccByteAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a TINYINT value that is designated by a named parameter marker as a byte value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public byte[] getJccBytesAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a BINARY or VARBINARY value that is designated by a named parameter marker as an array of byte values.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.Blob getJccClobAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a CLOB value that is designated by a named parameter marker as a java.sql.Clob value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.Date getJccDateAtName(String parameterMarkerName)
throws java.sql.SQLException
public java.sql.Date getJccDateAtName(String parameterMarkerName,
java.util.Calendar cal)
throws java.sql.SQLException
Retrieves a DATE value that is designated by a named parameter marker as a java.sql.Date value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public double getJccDoubleAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a DOUBLE value that is designated by a named parameter marker as a double value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public double getJccFloatAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a FLOAT value that is designated by a named parameter marker as a double value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public int getJccIntAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a INTEGER value that is designated by a named parameter marker as a int value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public long getJccLongAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a BIGINT value that is designated by a named parameter marker as a long value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.Object getJccObjectAtName(String parameterMarkerName)
throws java.sql.SQLException
public java.sql.Object getJccObjectAtName(String parameterMarkerName,
Map map)
throws java.sql.SQLException
Retrieves a value that is designated by a named parameter marker as a java.sql.Object value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.RowId getJccRowIdAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a ROWID value that is designated by a named parameter marker as a java.sql.RowId value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
This method requires the IBM Data Server Driver for JDBC and SQLJ Version 4.8 or later.
public short getJccShortAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a SMALLINT value that is designated by a named parameter marker as a short value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.SQLXML getJccSQLXMLAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a SQLXML value that is designated by a named parameter marker as a java.sql.SQLXML value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
This method requires the IBM Data Server Driver for JDBC and SQLJ Version 4.8 or later.
public java.lang.String getJccStringAtName(String parameterMarkerName)
throws java.sql.SQLException
Retrieves a CHAR, VARcHAR, or LONGVARCHAR value that is designated by a named parameter marker as a java.lang.String value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.Time getJccTimeAtName(String parameterMarkerName)
throws java.sql.SQLException
public java.sql.Time getJccTimeAtName(String parameterMarkerName,
java.util.Calendar cal)
throws java.sql.SQLException
Retrieves a TIME value that is designated by a named parameter marker as a java.sql.Time value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public java.sql.Timestamp getJccTimestampAtName(String parameterMarkerName)
throws java.sql.SQLException
public java.sql.Timestamp getJccTimestampAtName(String parameterMarkerName,
java.util.Calendar cal)
throws java.sql.SQLException
Retrieves a TIMESTAMP value that is designated by a named parameter marker as a java.sql.Timestamp value.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public void registerJccOutParameterAtName(String parameterMarkerName,
int sqlType)
throws java.sql.SQLException
public void registerJccOutParameterAtName(String parameterMarkerName,
int sqlType,
int scale)
throws java.sql.SQLException
public void registerJccOutParameterAtName(String parameterMarkerName,
int sqlType,
String typeName)
throws java.sql.SQLException
Registers an OUT parameter that is identified by parameterMarkerName as the JDBC type sqlType.
This method can be called only if the enableNamedParameterMarkers property is set to DB2BaseDataSource.YES (1).
public void setDBTimestamp(String parameterName,
DBTimestamp timestamp)
throws java.sql.SQLException
Assigns a DBTimestamp value to an IN or INOUT parameter.
This method is not supported for connections to IBM Informix.