|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
The IfmxCallableStatement interface extends the java.sql.CallableStatement interface.
Connection.prepareCall(java.lang.String)
,
ResultSet
Field Summary |
Fields inherited from interface java.sql.Statement |
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Method Summary | |
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. |
Methods inherited from interface java.sql.CallableStatement |
getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getObject, getObject, getObject, getObject, getRef, getRef, getShort, getShort, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setBigDecimal, setBinaryStream, setBoolean, setByte, setBytes, setCharacterStream, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull |
Methods inherited from interface java.sql.PreparedStatement |
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL |
Methods inherited from interface java.sql.Statement |
addBatch, cancel, clearBatch, clearWarnings, close, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
Method Detail |
public 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 value
java.sql.SQLException
- if there is no out parameter or if
parameterIndex is greater than the number of arguments.IfxTypes
public 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
public 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
public boolean hasOutParameter()
public void IfxSetNull(int i, int ifxType) throws java.sql.SQLException
Note: You must specify the parameter's Informix type.
ifxType
- Informix type code defined by com.informix.jdbc.IfxTypes
java.sql.SQLException
- if parameterIndex is greater than the number
of arguments.public void IfxSetNull(int i, int ifxType, java.lang.String name) throws java.sql.SQLException
Note: You must specify the parameter's Informix type.
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.public 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 string
java.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.public 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 string
java.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.
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |