com.informix.jdbc
Interface IfmxResultSet

All Superinterfaces:
java.sql.ResultSet

public interface IfmxResultSet
extends java.sql.ResultSet

The IfmxResultSet interface extends the java.sql.ResultSet interface.

See Also:
Statement.executeQuery(java.lang.String), Statement.getResultSet(), ResultSetMetaData

Field Summary
 
Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
 
Method Summary
 Interval getInterval(int columnIndex)
          Gets the value of a column in the current row as an Informix Interval.
 Interval getInterval(java.lang.String columnName)
          Gets the value of a column in the current row as an Informix Interval.
 IntervalDF getIntervalDF(int columnIndex)
          Gets the value of a column in the current row as an Informix IntervalDF.
 IntervalDF getIntervalDF(java.lang.String columnName)
          Gets the value of a column in the current row as an Informix IntervalDF.
 IntervalYM getIntervalYM(int columnIndex)
          Gets the value of a column in the current row as an Informix IntervalYM.
 IntervalYM getIntervalYM(java.lang.String columnName)
          Gets the value of a column in the current row as an Informix IntervalYM.
 java.lang.String getUnloadString(int columnIndex)
          Gets the value of a column in the current row in format compatible with SQL LOAD/UNLOAD format
 
Methods inherited from interface java.sql.ResultSet
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getInt, getLong, getLong, getMetaData, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
 

Method Detail

getInterval

public Interval getInterval(int columnIndex)
                     throws java.sql.SQLException
Gets the value of a column in the current row as an Informix Interval.

Parameters:
columnIndex - The first column is 1, the second is 2, and so on.
Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException

getInterval

public Interval getInterval(java.lang.String columnName)
                     throws java.sql.SQLException
Gets the value of a column in the current row as an Informix Interval.

Parameters:
columnName - The SQL name of the column.
Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException

getIntervalYM

public IntervalYM getIntervalYM(int columnIndex)
                         throws java.sql.SQLException
Gets the value of a column in the current row as an Informix IntervalYM.

Parameters:
columnIndex - The first column is 1, the second is 2, and so on.
Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException

getIntervalYM

public IntervalYM getIntervalYM(java.lang.String columnName)
                         throws java.sql.SQLException
Gets the value of a column in the current row as an Informix IntervalYM.

Parameters:
columnName - The SQL name of the column.
Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException

getIntervalDF

public IntervalDF getIntervalDF(int columnIndex)
                         throws java.sql.SQLException
Gets the value of a column in the current row as an Informix IntervalDF.

Parameters:
columnIndex - The first column is 1, the second is 2, and so on.
Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException

getIntervalDF

public IntervalDF getIntervalDF(java.lang.String columnName)
                         throws java.sql.SQLException
Gets the value of a column in the current row as an Informix IntervalDF.

Parameters:
columnName - The SQL name of the column.
Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException

getUnloadString

public java.lang.String getUnloadString(int columnIndex)
                                 throws java.sql.SQLException
Gets the value of a column in the current row in format compatible with SQL LOAD/UNLOAD format

Returns:
The column value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException