com.informix.jdbc
Interface IfmxStatement

All Superinterfaces:
java.sql.Statement

public interface IfmxStatement
extends java.sql.Statement

The IfmxStatement interface contains Informix extensions to the standard JDBC Statement interface.

See Also:
Connection.createStatement(), Statement, 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
 java.sql.ResultSet executeQuery(java.lang.String sql, boolean withHold)
          An Informix extension to execute an SQL statement that returns a single ResultSet.
 boolean getAutoFree()
          An Informix extension that returns the current autofree mode of this statement.
 int getSerial()
          An Informix extension that returns the serial value of the last row inserted.
 long getSerial8()
          An Informix extension that returns the serial8 value of the last row inserted.
 int getStatementType()
          An Informix extention to return the statement type returned by preparing the SQL statement.
 void setAutoFree(boolean flag)
          An Informix extension that allows the user to set the autofree property for this statement.
 
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

getSerial

public int getSerial()
              throws java.sql.SQLException
An Informix extension that returns the serial value of the last row inserted.

Returns:
The serial value of the last row inserted. If no rows were inserted, returns 0.
Throws:
java.sql.SQLException

getSerial8

public long getSerial8()
                throws java.sql.SQLException
An Informix extension that returns the serial8 value of the last row inserted.

Returns:
The serial8 value of the last row inserted. If no rows were inserted, returns 0.
Throws:
java.sql.SQLException

setAutoFree

public void setAutoFree(boolean flag)
An Informix extension that allows the user to set the autofree property for this statement. The resource for this statement is immediately released after the statement is executed. If the statement is a query, the resource is released after the last row is fetched.

Parameters:
flag - Indicates whether the autofree property is true (set) or false.

getAutoFree

public boolean getAutoFree()
An Informix extension that returns the current autofree mode of this statement.

Returns:
the autofree value of this statement: true (set) or false.

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql,
                                       boolean withHold)
                                throws java.sql.SQLException
An Informix extension to execute an SQL statement that returns a single ResultSet. The statement is executed with a hold cursor that spans across the transaction boundary.

Parameters:
sql - The SQL statement.
withHold - Specifies whether the cursor has a hold or not.
Returns:
the table of data produced by the SQL statement.
Throws:
java.sql.SQLException

getStatementType

public int getStatementType()
An Informix extention to return the statement type returned by preparing the SQL statement. The number returned by this method can be deciphered by looking into the IfxStatementTypes.java file that is now exported to the user.

Returns:
the statement type id