public interface IfmxCallableStatement
extends java.sql.CallableStatement
The IfmxCallableStatement interface extends the java.sql.CallableStatement interface.
Connection.prepareCall(java.lang.String)
,
ResultSet
Modifier and Type | Method and Description |
---|---|
boolean |
hasOutParameter()
Returns true if the routine has an output parameter.
|
void |
IfxRegisterOutParameter(int parameterIndex,
int ifxType)
Registers the output parameter using type definitions in IfxTypes.
|
void |
IfxRegisterOutParameter(int parameterIndex,
int ifxType,
int scale)
Use this version of IfxRegisterOutParameter for registering
IFX_TYPE_DECIMAL, IFX_TYPE_DATETIME or IFX_TYPE_INTERVAL out parameters.
|
void |
IfxRegisterOutParameter(int parameterIndex,
int ifxType,
java.lang.String name)
Registers the output parameter using IfxTypes and data type name.
|
void |
IfxSetNull(int i,
int ifxType)
Set a parameter to SQL NULL.
|
void |
IfxSetNull(int i,
int ifxType,
java.lang.String name)
Set a parameter to SQL NULL.
|
void |
setArray(int i,
java.sql.Array x,
java.lang.String collectionType)
Set an Array parameter.
|
void |
setObject(int i,
java.sql.Array x,
java.lang.String collectionType)
Set an Object parameter.
|
getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
void IfxRegisterOutParameter(int parameterIndex, int ifxType) throws java.sql.SQLException
parameterIndex
- the first parameter is 1, the second is 2,...ifxType
- type code defined by com.informix.IfxTypes
for parameters of type Numeric, Decimal, Datetime or Interval use
the version of IfxRegisterOutParameter that accepts a scale valuejava.sql.SQLException
- if there is no out parameter or if
parameterIndex is greater than the number of arguments.IfxTypes
void IfxRegisterOutParameter(int parameterIndex, int ifxType, java.lang.String name) throws java.sql.SQLException
parameterIndex
- the first parameter is 1, the second is 2,...ifxType
- type code defined by com.informix.IfxTypes
for parameters of type Numeric, Decimal, Datetime or Interval use
the version of IfxRegisterOutParameter that accepts a scale valuename
- Opaque type name, named row name, distinct type name or
collection / unnamed row definition.java.sql.SQLException
- if there is no out parameter, if
parameterIndex is greater than the number of arguments or if the
type is not UDTVAR or UDTFIXED.IfxTypes
void IfxRegisterOutParameter(int parameterIndex, int ifxType, int scale) throws java.sql.SQLException
parameterIndex
- the first parameter is 1, the second is 2, ...ifxType
- use either com.informix.lang.IfxTypes.IFX_TYPE_DECIMAL,
com.informix.lang.IfxTypes.IFX_TYPE_DATETIME or
com.informix.lang.IfxTypes.IFX_TYPE_INTERVALscale
- a value greater than or equal to zero representing the
desired number of digits to the right of the decimal point
or the encoded length for datetime and intervals.java.sql.SQLException
- if there is no out parameter or if
parameterIndex is greater than the number of arguments.IfxTypes
boolean hasOutParameter()
void IfxSetNull(int i, int ifxType) throws java.sql.SQLException
Note: You must specify the parameter's Informix type.
parameterIndex
- the first parameter is 1, the second is 2, ...ifxType
- Informix type code defined by com.informix.jdbc.IfxTypesjava.sql.SQLException
- if parameterIndex is greater than the number
of arguments.void IfxSetNull(int i, int ifxType, java.lang.String name) throws java.sql.SQLException
Note: You must specify the parameter's Informix type.
parameterIndex
- the first parameter is 1, the second is 2, ...ifxType
- Informix type code defined by com.informix.jdbc.IfxTypesname
- Opaque type name, named row name, distinct type name or
collection / unnamed row definition.java.sql.SQLException
- if parameterIndex is greater than the number
of arguments.void setArray(int i, java.sql.Array x, java.lang.String collectionType) throws java.sql.SQLException
i
- the first parameter is 1, the second is 2, ...x
- an object representing an SQL arraycollectionType
- Collection definition stringjava.sql.SQLException
- if parameterIndex is greater than the number
of arguments or a conversion error occurs.java.sql.SQLException
- if a database-access error occurs.void setObject(int i, java.sql.Array x, java.lang.String collectionType) throws java.sql.SQLException
i
- the first parameter is 1, the second is 2, ...x
- an object representing an SQL arraycollectionType
- Collection definition stringjava.sql.SQLException
- if parameterIndex is greater than the number
of arguments or a conversion error occurs.java.sql.SQLException
- if a database-access error occurs.