AS400JDBCPreparedStatementRedirect (JTOpen 20.0.7 API)

java.lang.Object
- com.ibm.as400.access.AS400JDBCStatement
- - com.ibm.as400.access.AS400JDBCPreparedStatement
  - - com.ibm.as400.access.AS400JDBCPreparedStatementRedirect

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

Direct Known Subclasses:

AS400JDBCCallableStatementRedirect
```
public class AS400JDBCPreparedStatementRedirect
extends AS400JDBCPreparedStatement
```

Field Summary
- Fields inherited from class com.ibm.as400.access.AS400JDBCStatement
  extendedColumnDescriptors_
- 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

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`void`	`addBatch()`	Adds the set of parameters to the current batch.
`void`	`addBatch(String sql)`	Adds an SQL statement to the current batch of SQL statements.
`void`	`cancel()`	Cancels the statement.
`void`	`clearBatch()`	Clears the current batch of SQL statements.
`void`	`clearParameters()`	Releases the resources used by the current input parameter values.
`void`	`clearWarnings()`	Clears all warnings that have been reported for the statement.
`void`	`close()`	Releases the statement's resources immediately instead of waiting for them to be automatically released.
`void`	`closeOnCompletion()`	Specifies that this Statement will be closed when all its dependent result sets are closed.
`protected void`	`endCancelThread()`	endTheCancelThread
`boolean`	`execute()`	Runs an SQL statement that may return multiple result sets.
`boolean`	`execute(String sql)`	Runs an SQL statement that may return multiple result sets.
`boolean`	`execute(String sql, int autoGeneratedKeys)`	Runs an SQL statement that may return multiple result sets and makes any auto-generated keys available for retrieval using Statement.getGeneratedKeys().
`boolean`	`execute(String sql, int[] columnIndexes)`	Runs an SQL statement that may return multiple result sets and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys().
`boolean`	`execute(String sql, String[] columnNames)`	Runs an SQL statement that may return multiple result sets and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys().
`int[]`	`executeBatch()`	Runs the batch of SQL statements.
`long[]`	`executeLargeBatch()`	Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
`long`	`executeLargeUpdate()`	Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
`long`	`executeLargeUpdate(String sql)`	Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
`long`	`executeLargeUpdate(String sql, int autoGeneratedKeys)`	Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
`long`	`executeLargeUpdate(String sql, int[] columnIndexes)`	Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
`long`	`executeLargeUpdate(String sql, String[] columnNames)`	Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
`ResultSet`	`executeQuery()`	Runs the SQL statement that returns a single result set.
`ResultSet`	`executeQuery(String sql)`	Runs an SQL statement that returns a single result set.
`int`	`executeUpdate()`	Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set.
`int`	`executeUpdate(String sql)`	Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set.
`int`	`executeUpdate(String sql, int autoGeneratedKeys)`	Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set and makes any auto-generated keys available for retrieval using Statement.getGeneratedKeys().
`int`	`executeUpdate(String sql, int[] columnIndexes)`	Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys().
`int`	`executeUpdate(String sql, String[] columnNames)`	Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys().
`Connection`	`getConnection()`	Returns the connection for this statement.
`String`	`getDB2ParameterName(int parm)`	Return the name of the parameter for a stored procedure call.
`int`	`getFetchDirection()`	Returns the fetch direction.
`int`	`getFetchSize()`	Returns the fetch size.
`ResultSet`	`getGeneratedKeys()`	Retrieves any auto-generated keys created as a result of executing this Statement object.
`long`	`getLargeMaxRows()`	Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
`long`	`getLargeUpdateCount()`	Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
`int`	`getMaxFieldSize()`	Returns the maximum field size limit for the statement.
`int`	`getMaxRows()`	Returns the maximum rows limit for the statement.
`ResultSetMetaData`	`getMetaData()`	Returns the ResultSetMetaData object that describes the result set's columns.
`boolean`	`getMoreResults()`	Returns the next result set.
`boolean`	`getMoreResults(int current)`	Returns the next result set.
`ParameterMetaData`	`getParameterMetaData()`	Returns the number, types, and properties of a PreparedStatement object's parameters.
`int`	`getPositionOfSyntaxError()`	Will return the value of the last syntax error that came back from the IBM i system.
`int`	`getQueryTimeout()`	Returns the query timeout limit for this statement.
`ResultSet`	`getResultSet()`	Returns the current result set.
`int`	`getResultSetConcurrency()`	Returns the result set concurrency to be used for this statement.
`int`	`getResultSetHoldability()`	Returns the result set cursor holdability to be used for this statement.
`int`	`getResultSetType()`	Returns the result set type to be used for this statement.
`int`	`getUpdateCount()`	Returns the current update count.
`protected String[]`	`getValidWrappedList()`
`SQLWarning`	`getWarnings()`	Returns the first warning reported for the statement.
`boolean`	`isClosed()`	Indicates if the statement is closed.
`boolean`	`isCloseOnCompletion()`	Returns a value indicating whether this Statement will be closed when all its dependent result sets are closed.
`boolean`	`isPoolable()`	Returns the value of the statements poolable hint, indicating whether pooling of the statement is requested.
`boolean`	`isWrapperFor(Class<?> iface)`	Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
`void`	`setArray(int parameterIndex, Array x)`	Sets an input parameter to an Array value.
`void`	`setAsciiStream(int parameterIndex, InputStream stream)`	Sets the designated parameter to the given input stream.
`void`	`setAsciiStream(int parameterIndex, InputStream x, int length)`	Sets an input parameter to an ASCII stream value.
`void`	`setAsciiStream(int parameterIndex, InputStream stream, long length)`	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void`	`setBigDecimal(int parameterIndex, BigDecimal x)`	Sets an input parameter to a BigDecimal value.
`void`	`setBinaryStream(int parameterIndex, InputStream stream)`	Sets the designated parameter to the given input stream.
`void`	`setBinaryStream(int parameterIndex, InputStream stream, int length)`	Sets an input parameter to a binary stream value.
`void`	`setBinaryStream(int parameterIndex, InputStream stream, long length)`	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void`	`setBlob(int parameterIndex, InputStream stream)`	Sets the designated parameter to a `InputStream` object.
`void`	`setBlob(int parameterIndex, InputStream stream, long length)`	Sets the designated parameter to an `InputStream` object.
`void`	`setBlob(int parameterIndex, Blob x)`	Sets an input parameter to a Blob value.
`void`	`setBoolean(int parameterIndex, boolean x)`	Sets an input parameter to a Java boolean value.
`void`	`setByte(int parameterIndex, byte x)`	Sets an input parameter to a Java byte value.
`void`	`setBytes(int parameterIndex, byte[] x)`	Sets an input parameter to a Java byte array value.
`void`	`setCharacterStream(int parameterIndex, Reader reader)`	Sets the designated parameter to the given `Reader` object.
`void`	`setCharacterStream(int parameterIndex, Reader reader, int length)`	Sets an input parameter to a character stream value.
`void`	`setCharacterStream(int parameterIndex, Reader reader, long length)`	Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
`void`	`setClob(int parameterIndex, Reader reader)`	Sets the designated parameter to a `Reader` object.
`void`	`setClob(int parameterIndex, Reader reader, long length)`	Sets the designated parameter to a `Reader` object.
`void`	`setClob(int parameterIndex, Clob x)`	Sets an input parameter to a Clob value.
`void`	`setCursorName(String name)`	Sets the SQL cursor name that will be used by the statement.
`void`	`setDate(int parameterIndex, Date x)`	Sets an input parameter to a java.sql.Date value using the default calendar.
`void`	`setDate(int parameterIndex, Date x, Calendar cal)`	Sets an input parameter to a java.sql.Date value using a calendar other than the default.
`void`	`setDB2Default(int parameterIndex)`	Sets an input parameter to the default value
`void`	`setDB2Unassigned(int parameterIndex)`	Sets an input parameter to unassigned
`void`	`setDBDefault(int parameterIndex)`	Sets an input parameter to the default value.
`void`	`setDBUnassigned(int parameterIndex)`	Sets an input parameter to unassigned.
`void`	`setDouble(int parameterIndex, double x)`	Sets an input parameter to a Java double value.
`void`	`setEscapeProcessing(boolean enable)`	Sets the escape processing mode.
`void`	`setFetchDirection(int direction)`	Sets the direction in which the rows in a result set will be processed.
`void`	`setFetchSize(int rows)`	Sets the number of rows to be fetched from the database when more rows are needed.
`void`	`setFloat(int parameterIndex, float x)`	Sets an input parameter to a Java float value.
`void`	`setInt(int parameterIndex, int x)`	Sets an input parameter to a Java int value.
`void`	`setLargeMaxRows(long max)`	Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.
`void`	`setLong(int parameterIndex, long x)`	Sets an input parameter to a Java long value.
`void`	`setMaxFieldSize(int max)`	Sets the maximum field size limit.
`void`	`setMaxRows(int max)`	Sets the maximum rows limit.
`void`	`setNCharacterStream(int parameterIndex, Reader reader)`	Sets the designated parameter to a `Reader` object.
`void`	`setNCharacterStream(int parameterIndex, Reader reader, long length)`	Sets the designated parameter to a `Reader` object.
`void`	`setNClob(int parameterIndex, Reader reader)`	Sets the designated parameter to a `Reader` object.
`void`	`setNClob(int parameterIndex, Reader reader, long length)`	Sets the designated parameter to a `Reader` object.
`void`	`setNClob(int parameterIndex, NClob clob)`	Sets the designated parameter to a `java.sql.NClob` object.
`void`	`setNString(int parameterIndex, String x)`	Sets the designated paramter to the given `String` object.
`void`	`setNull(int parameterIndex, int sqlType)`	Sets an input parameter to SQL NULL.
`void`	`setNull(int parameterIndex, int sqlType, String typeName)`	Sets an input parameter to SQL NULL.
`void`	`setObject(int parameterIndex, Object x)`	Sets an input parameter to an Object value.
`void`	`setObject(int parameterIndex, Object x, int targetSqlType)`	Sets an input parameter to an Object value.
`void`	`setObject(int parameterIndex, Object x, int targetSqlType, int scale)`	Sets an input parameter to an Object value.
`void`	`setObject(int parameterIndex, Object x, SQLType targetSqlType)`	Sets the value of the designated parameter with the given object.
`void`	`setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)`	Sets the value of the designated parameter with the given object.
`void`	`setPoolable(boolean poolable)`	Requests that a `Statement` be pooled or not pooled.
`void`	`setQueryTimeout(int seconds)`	Sets the query timeout limit.
`void`	`setRef(int parameterIndex, Ref x)`	Sets an input parameter to a Ref value.
`void`	`setRowId(int parameterIndex, RowId x)`	Sets the designated parameter to the given `java.sql.RowId` object.
`void`	`setShort(int parameterIndex, short x)`	Sets an input parameter to a Java short value.
`void`	`setSQLXML(int parameterIndex, SQLXML xml)`	Sets the designated parameter to the given `java.sql.SQLXML` object.
`void`	`setString(int parameterIndex, String x)`	Sets an input parameter to a String value.
`void`	`setTime(int parameterIndex, Time x)`	Sets an input parameter to a java.sql.Time value using the default calendar.
`void`	`setTime(int parameterIndex, Time x, Calendar cal)`	Sets an input parameter to a java.sql.Time value using a calendar other than the default.
`void`	`setTimestamp(int parameterIndex, Timestamp x)`	Sets an input parameter to a java.sql.Timestamp value using the default calendar.
`void`	`setTimestamp(int parameterIndex, Timestamp x, Calendar cal)`	Sets an input parameter to a java.sql.Timestamp value using a calendar other than the default.
`void`	`setUnicodeStream(int parameterIndex, InputStream x, int length)`	Sets an input parameter to a Unicode stream value.
`void`	`setURL(int parameterIndex, URL x)`	Sets an input parameter to a URL value.
`protected void`	`startCancelThread()`	Handles the work involved in supporting a setQueryTimeout option with the cancel property set.
`String`	`toString()`	Returns the statement name.
`<T> T`	`unwrap(Class<T> iface)`	Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

Methods inherited from class com.ibm.as400.access.AS400JDBCStatement
finalize

Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.Statement
enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, isSimpleIdentifier

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

- Method Detail
  - addBatch
```
public void addBatch(String sql)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Adds an SQL statement to the current batch of SQL statements.
    Do not use this form of addBatch() on a prepared statement.
    
    Specified by:
    
    addBatch in interface Statement
    
    Specified by:
    
    addBatch in class AS400JDBCPreparedStatement
    
    Parameters:
    
    sql - The SQL statement to be added to the current batch. This can be any SQL statement that does not return a result set.
    
    Throws:
    
    SQLException - This exception is always thrown.
  - cancel
```
public void cancel()
            throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Cancels the statement. This is useful when one thread needs to cancel a statement that is being executed by another thread. This will close the current result set.
    
    Specified by:
    
    cancel in interface Statement
    
    Overrides:
    
    cancel in class AS400JDBCStatement
    
    Throws:
    
    SQLException - If the statement is not open or an error occurs.
  - clearBatch
```
public void clearBatch()
                throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Clears the current batch of SQL statements.
    
    Specified by:
    
    clearBatch in interface Statement
    
    Overrides:
    
    clearBatch in class AS400JDBCStatement
    
    Throws:
    
    SQLException - If the statement is not open.
  - clearWarnings
```
public void clearWarnings()
                   throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Clears all warnings that have been reported for the statement. After this call, getWarnings() returns null until a new warning is reported for the statement.
    
    Specified by:
    
    clearWarnings in interface Statement
    
    Overrides:
    
    clearWarnings in class AS400JDBCStatement
    
    Throws:
    
    SQLException - If an error occurs.
  - close
```
public void close()
           throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Releases the statement's resources immediately instead of waiting for them to be automatically released. This closes the current result set.
    
    Specified by:
    
    close in interface AutoCloseable
    
    Specified by:
    
    close in interface Statement
    
    Overrides:
    
    close in class AS400JDBCStatement
    
    Throws:
    
    SQLException - If an error occurs.
  - execute
```
public boolean execute(String sql)
                throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL statement that may return multiple result sets. This closes the current result set and clears warnings before executing a new SQL statement.
    Do not use this form of execute() on a prepared statement.
    
    Specified by:
    
    execute in interface Statement
    
    Specified by:
    
    execute in class AS400JDBCPreparedStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    Returns:
    
    true if a result set was returned, false if an update count was returned or nothing was returned.
    
    Throws:
    
    SQLException - This exception is always thrown.
  - execute
```
public boolean execute(String sql,
                       int autoGeneratedKeys)
                throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL statement that may return multiple result sets and makes any auto-generated keys available for retrieval using Statement.getGeneratedKeys(). This closes the current result set and clears warnings before executing the new SQL statement.
    Do not use this form of execute() on a prepared statement.
    
    Specified by:
    
    execute in interface Statement
    
    Specified by:
    
    execute in class AS400JDBCPreparedStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    autoGeneratedKeys - Indicates whether auto-generated keys should be made available for retrieval. Valid values are Statement.RETURN_GENERATED_KEYS and Statement.NO_GENERATED_KEYS.
    
    Returns:
    
    true if a result set was returned, false if an update count was returned or nothing was returned.
    
    Throws:
    
    SQLException - This exception is always thrown.
  - execute
```
public boolean execute(String sql,
                       int[] columnIndexes)
                throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Runs an SQL statement that may return multiple result sets and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys(). This closes the current result set and clears warnings before executing the new SQL statement.
    Under some situations, a single SQL statement may return multiple result sets, an update count, or both. This might occur when executing a stored procedure that returns multiple result sets or when dynamically executing an unknown SQL string.
    Use getMoreResults(), getResultSet(), and getUpdateCount() to navigate through multiple result sets, an update count, or both.
    This method is not supported when connecting to IBM i V5R4 or earlier systems.
    
    Specified by:
    
    execute in interface Statement
    
    Overrides:
    
    execute in class AS400JDBCStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    columnIndexes - Indicates that auto-generated keys for the indicated columns should be made available for retrieval.
    
    Returns:
    
    true if a result set was returned, false if an update count was returned or nothing was returned.
    
    Throws:
    
    SQLException - - If connecting to IBM i V5R4 or earlier systems, if the statement is not open, the SQL statement contains a syntax error, the query timeout limit is exceeded, the value for columnIndexes is not a valid value, or an error occurs.
  - execute
```
public boolean execute(String sql,
                       String[] columnNames)
                throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Runs an SQL statement that may return multiple result sets and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys(). This closes the current result set and clears warnings before executing the new SQL statement.
    Under some situations, a single SQL statement may return multiple result sets, an update count, or both. This might occur when executing a stored procedure that returns multiple result sets or when dynamically executing an unknown SQL string.
    Use getMoreResults(), getResultSet(), and getUpdateCount() to navigate through multiple result sets, an update count, or both.
    This method is not supported when connecting to IBM i V5R4 or earlier systems.
    
    Specified by:
    
    execute in interface Statement
    
    Overrides:
    
    execute in class AS400JDBCStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    columnNames - Indicates that auto-generated keys for the indicated columns should be made available for retrieval.
    
    Returns:
    
    true if a result set was returned, false if an update count was returned or nothing was returned.
    
    Throws:
    
    SQLException - - If connecting to IBM i V5R4 or earlier systems, if the statement is not open, the SQL statement contains a syntax error, the query timeout limit is exceeded, the value for columnNames is not a valid value, or an error occurs.
  - executeBatch
```
public int[] executeBatch()
                   throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs the batch of SQL statements. Batch updates can be used to submit a set of SQL statements together as a single unit. The SQL statements are run in the order in which they were added to the batch. The batch is cleared after the SQL statements are run. In addition, this closes the current result set and clears warnings before executing the new SQL statement.
    When batch updates are run, autocommit should usually be turned off. This allows the caller to decide whether or not to commit the transaction in the event that an error occurs and some of the SQL statements in a batch fail to run.
    
    Specified by:
    
    executeBatch in interface Statement
    
    Specified by:
    
    executeBatch in class AS400JDBCPreparedStatement
    
    Returns:
    
    An array of row counts for the SQL statements that are run. The array contains one element for each statement in the batch of SQL statements. The array is ordered according to the order in which the SQL statements were added to the batch.
    
    Throws:
    
    SQLException - If the statement is not open, an SQL statement contains a syntax error, the query timeout limit is exceeded, an SQL statement returns a result set, or an error occurs.
  - executeQuery
```
public ResultSet executeQuery(String sql)
                       throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL statement that returns a single result set. This closes the current result set and clears warnings before executing a new SQL statement.
    Do not use this form of executeQuery() on a prepared statement.
    
    Specified by:
    
    executeQuery in interface Statement
    
    Specified by:
    
    executeQuery in class AS400JDBCPreparedStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    Returns:
    
    The result set that contains the data produced by the query.
    
    Throws:
    
    SQLException - This exception is always thrown.
  - executeUpdate
```
public int executeUpdate(String sql)
                  throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set. This closes the current result set and clears warnings before executing a new SQL statement.
    Do not use this form of executeUpdate() on a prepared statement.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Specified by:
    
    executeUpdate in class AS400JDBCPreparedStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    Returns:
    
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    SQLException - This exception is always thrown.
  - executeUpdate
```
public int executeUpdate(String sql,
                         int autoGeneratedKeys)
                  throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set and makes any auto-generated keys available for retrieval using Statement.getGeneratedKeys(). This closes the current result set and clears warnings before executing the new SQL statement.
    Do not use this form of executeUpdate() on a prepared statement.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Specified by:
    
    executeUpdate in class AS400JDBCPreparedStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    Returns:
    
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    SQLException - This exception is always thrown.
  - executeUpdate
```
public int executeUpdate(String sql,
                         int[] columnIndexes)
                  throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys(). This closes the current result set and clears warnings before executing the new SQL statement.
    This method is not supported when connecting to IBM i V5R4 or earlier systems.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Overrides:
    
    executeUpdate in class AS400JDBCStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    columnIndexes - The indexes of columns for which auto-generated keys should be made available for retrieval.
    
    Returns:
    
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    SQLException - If connection to IBM i V5R4 or earlier systems, the statement is not open, the SQL statement contains a syntax error, the query timeout limit is exceeded, the statement returns a result set, the value for autoGeneratedKeys is not a valid value or an error occurs.
  - executeUpdate
```
public int executeUpdate(String sql,
                         String[] columnNames)
                  throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set and makes any auto-generated keys for the columns indicated in the given array available for retrieval using Statement.getGeneratedKeys(). This closes the current result set and clears warnings before executing the new SQL statement.
    This method is not supported when connecting to IBM i V5R4 or earlier systems.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Overrides:
    
    executeUpdate in class AS400JDBCStatement
    
    Parameters:
    
    sql - The SQL statement.
    
    columnNames - The column names for which auto-generated keys should be made available for retrieval.
    
    Returns:
    
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    SQLException - If connection to IBM i V5R4 or earlier systems, the statement is not open, the SQL statement contains a syntax error, the query timeout limit is exceeded, the statement returns a result set, the value for autoGeneratedKeys is not a valid value or an error occurs.
  - getConnection
```
public Connection getConnection()
                         throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the connection for this statement.
    
    Specified by:
    
    getConnection in interface Statement
    
    Overrides:
    
    getConnection in class AS400JDBCStatement
    
    Returns:
    
    The connection for this statement.
    
    Throws:
    
    SQLException - If an error occurs.
  - getFetchDirection
```
public int getFetchDirection()
                      throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the fetch direction.
    
    Specified by:
    
    getFetchDirection in interface Statement
    
    Overrides:
    
    getFetchDirection in class AS400JDBCStatement
    
    Returns:
    
    The fetch direction.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getFetchSize
```
public int getFetchSize()
                 throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the fetch size.
    
    Specified by:
    
    getFetchSize in interface Statement
    
    Overrides:
    
    getFetchSize in class AS400JDBCStatement
    
    Returns:
    
    The fetch size.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getGeneratedKeys
```
public ResultSet getGeneratedKeys()
                           throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Retrieves any auto-generated keys created as a result of executing this Statement object.
    In order for this method to return auto-generated keys, the statement must be executed on a table with an identity column. For more information about identity columns, Go to the IBM i Information Center, and search on the phrase "identity column".
    This method will return null if the user did not request auto-generated keys during the execute of a Statement or during the prepare of a PreparedStatement. This method will also return null if the application has not executed the statement before calling this method.
    This method will return an empty result set if the database did not generate any auto-generated keys when executing the statement.
    
    Specified by:
    
    getGeneratedKeys in interface Statement
    
    Overrides:
    
    getGeneratedKeys in class AS400JDBCStatement
    
    Returns:
    
    The ResultSet object containing the auto-generated key(s) generated by the execution of this Statement object, an empty result set if the database did not generate any auto-generated keys, or null if the application did not request auto-generated keys or did not execute the statement before calling this method.
    
    Throws:
    
    SQLException - If the statement is not open, if connecting to OS/400 V5R1 or earlier, an error occurs.
  - getMaxFieldSize
```
public int getMaxFieldSize()
                    throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the maximum field size limit for the statement. The maximum field size limit is the maximum amount of data returned for any column value. It applies only to BINARY, VARBINARY, CHAR, and VARCHAR fields. If the limit is exceeded, then the excess data is discarded.
    
    Specified by:
    
    getMaxFieldSize in interface Statement
    
    Overrides:
    
    getMaxFieldSize in class AS400JDBCStatement
    
    Returns:
    
    The maximum field size limit (in bytes), or 0 for no limit.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getMaxRows
```
public int getMaxRows()
               throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the maximum rows limit for the statement. The maximum rows limit is the maximum number of rows that a result set can contain. If the limit is exceeded, then the excess rows are dropped.
    
    Specified by:
    
    getMaxRows in interface Statement
    
    Overrides:
    
    getMaxRows in class AS400JDBCStatement
    
    Returns:
    
    The maximum rows limit, or 0 for no limit.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getMoreResults
```
public boolean getMoreResults()
                       throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the next result set. This closes the current result set.
    
    Specified by:
    
    getMoreResults in interface Statement
    
    Overrides:
    
    getMoreResults in class AS400JDBCStatement
    
    Returns:
    
    true if another result set is available, false if there are no more result sets.
    
    Throws:
    
    SQLException - If an error occurs.
  - getMoreResults
```
public boolean getMoreResults(int current)
                       throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the next result set. This closes the current result set. This method handles any current ResultSet object(s) according to the instructions specified by the actionOnCurrentResultSet parameter, and returns true if the next result is a ResultSet object.
    
    Specified by:
    
    getMoreResults in interface Statement
    
    Overrides:
    
    getMoreResults in class AS400JDBCStatement
    
    Parameters:
    
    current - What should happen to current ResultSet objects obtained using the method getResultSet. Valid values are CLOSE_CURRENT_RESULT, KEEP_CURRENT_RESULT, and CLOSE_ALL_RESULTS.
    
    Returns:
    
    Always false because this method is not supported.
    
    Throws:
    
    SQLException - if DatabaseMetaData.supportsMultipleOpenResults returns false and either Statement.KEEP_CURRENT_RESULT or Statement.CLOSE_ALL_RESULTS are supplied as the argument.
  - getPositionOfSyntaxError
```
public int getPositionOfSyntaxError()
                             throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Will return the value of the last syntax error that came back from the IBM i system.
    
    Overrides:
    
    getPositionOfSyntaxError in class AS400JDBCStatement
    
    Returns:
    
    The value of the character of the last syntax error from the system, or 0 if no errors occurred or the value is not known.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getQueryTimeout
```
public int getQueryTimeout()
                    throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the query timeout limit for this statement. The query timeout limit is the number of seconds that the driver will wait for an SQL statement to execute.
    
    Specified by:
    
    getQueryTimeout in interface Statement
    
    Overrides:
    
    getQueryTimeout in class AS400JDBCStatement
    
    Returns:
    
    The query timeout limit (in seconds), or 0 for no limit.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getResultSet
```
public ResultSet getResultSet()
                       throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the current result set.
    
    Specified by:
    
    getResultSet in interface Statement
    
    Overrides:
    
    getResultSet in class AS400JDBCStatement
    
    Returns:
    
    The current result set, or null if an update count was returned or there are no more result sets.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getResultSetConcurrency
```
public int getResultSetConcurrency()
                            throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the result set concurrency to be used for this statement.
    
    Specified by:
    
    getResultSetConcurrency in interface Statement
    
    Overrides:
    
    getResultSetConcurrency in class AS400JDBCStatement
    
    Returns:
    
    The result set concurrency.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getResultSetHoldability
```
public int getResultSetHoldability()
                            throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the result set cursor holdability to be used for this statement.
    Specified by:
    
    getResultSetHoldability in interface Statement
    
    Overrides:
    
    getResultSetHoldability in class AS400JDBCStatement
    
    Returns:
    The cursor holdability. Valid values are ResultSet.HOLD_CURSORS_OVER_COMMIT and ResultSet.CLOSE_CURSORS_AT_COMMIT. The holdability is derived in this order of precedence:
    
    1. The holdability, if any, that was specified on statement creation using the methods createStatement(), prepareCall(), or prepareStatement() on the Connection object.
    2. The holdability specified using the method setHoldability(int) if this method was called on the Connection object.
    3. If neither of above methods were called, the value of the cursor hold driver property.
    Full functionality of #1 and #2 requires OS/400 v5r2 or IBM i. If connecting to OS/400 V5R1 or earlier, the value specified on these two methods will be ignored and the default holdability will be the value of #3.
    Throws:
    
    SQLException - If the statement is not open.
  - getResultSetType
```
public int getResultSetType()
                     throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the result set type to be used for this statement.
    
    Specified by:
    
    getResultSetType in interface Statement
    
    Overrides:
    
    getResultSetType in class AS400JDBCStatement
    
    Returns:
    
    The result set type.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getUpdateCount
```
public int getUpdateCount()
                   throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the current update count.
    
    Specified by:
    
    getUpdateCount in interface Statement
    
    Overrides:
    
    getUpdateCount in class AS400JDBCStatement
    
    Returns:
    
    The update count, or -1 if a result set was returned or there are no more result sets.
    
    Throws:
    
    SQLException - If the statement is not open.
  - getWarnings
```
public SQLWarning getWarnings()
                       throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the first warning reported for the statement. Subsequent warnings may be chained to this warning.
    
    Specified by:
    
    getWarnings in interface Statement
    
    Overrides:
    
    getWarnings in class AS400JDBCStatement
    
    Returns:
    
    The first warning, or null if no warnings have been reported.
    
    Throws:
    
    SQLException - If an error occurs.
  - isClosed
```
public boolean isClosed()
                 throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Indicates if the statement is closed.
    
    Specified by:
    
    isClosed in interface Statement
    
    Overrides:
    
    isClosed in class AS400JDBCStatement
    
    Returns:
    
    true if the statement is closed; false otherwise.
    
    Throws:
    
    SQLException - If a database error occurs.
  - setCursorName
```
public void setCursorName(String name)
                   throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the SQL cursor name that will be used by the statement. Cursor names must be unique within the connection. The cursor name can only be set when no result set is open.
    The cursor name can be used in SQL positioned UPDATE or DELETE statements to identify the current row in the result set generated by this statement. By definition, SQL positioned UPDATEs or DELETEs must be executed by a different statement than the one that generated the result set being used for positioning.
    Cursor names are case sensitive. However, when using a cursor name within other SQL positioned UPDATE or DELETE statements, the cursor name will be uppercased. If you use a cursor name with lowercase characters, you need to enclose it in double quotes when referring to it in other SQL statements.
    
    Specified by:
    
    setCursorName in interface Statement
    
    Overrides:
    
    setCursorName in class AS400JDBCStatement
    
    Parameters:
    
    name - The cursor name. If null, a unique default name will be used.
    
    Throws:
    
    SQLException - If the statement is not open, a result set is open, the cursor name is not unique within the connection, or an error occurs.
  - setEscapeProcessing
```
public void setEscapeProcessing(boolean enable)
                         throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the escape processing mode. When processing escape clauses, the JDBC driver substitutes escape clauses in SQL statements with DB2 for IBM i SQL grammar elements. If escape processing is not needed, then setting the escape processing mode to false improves performance.
    
    Specified by:
    
    setEscapeProcessing in interface Statement
    
    Overrides:
    
    setEscapeProcessing in class AS400JDBCStatement
    
    Parameters:
    
    enable - true to process escape clauses; false otherwise. The default is true.
    
    Throws:
    
    SQLException - If the statement is not open.
  - setFetchDirection
```
public void setFetchDirection(int direction)
                       throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the direction in which the rows in a result set will be processed.
    This setting is not used.
    Specified by:
    
    setFetchDirection in interface Statement
    
    Overrides:
    
    setFetchDirection in class AS400JDBCStatement
    
    Parameters:
    direction - The fetch direction for processing rows. Valid values are:
    
    ResultSet.FETCH_FORWARD
    ResultSet.FETCH_REVERSE
    ResultSet.FETCH_UNKNOWN
    The default is ResultSet.FETCH_FORWARD.
    Throws:
    
    SQLException - If the statement is not open, the result set type is ResultSet.TYPE_FORWARD_ONLY, and the input value is not ResultSet.FETCH_FORWARD, or the input value is not valid.
  - setFetchSize
```
public void setFetchSize(int rows)
                  throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the number of rows to be fetched from the database when more rows are needed. The number of rows specified only affects result sets created using this statement. If the value specified is zero, then the driver will choose an appropriate fetch size.
    This setting only affects statements that meet the criteria specified in the "block criteria" property. The fetch size is only used if the "block size" property is set to "0".
    This setting only takes effect for result sets that are opened after this method has been called. Ideally, this method should be called before the statement is executed.
    
    Specified by:
    
    setFetchSize in interface Statement
    
    Overrides:
    
    setFetchSize in class AS400JDBCStatement
    
    Parameters:
    
    rows - The number of rows. This must be greater than or equal to 0 and less than or equal to the maximum rows limit. The default is zero.
    
    Throws:
    
    SQLException - If the statement is not open or the input value is not valid.
  - setMaxFieldSize
```
public void setMaxFieldSize(int max)
                     throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the maximum field size limit. The maximum field size limit is the maximum amount of data returned for any column value. It applies only to BINARY, VARBINARY, CHAR, and VARCHAR fields. If the limit is exceeded, then the excess data is discarded.
    
    Specified by:
    
    setMaxFieldSize in interface Statement
    
    Overrides:
    
    setMaxFieldSize in class AS400JDBCStatement
    
    Parameters:
    
    max - The maximum field size limit (in bytes) or 0 for no limit. The default is 0.
    
    Throws:
    
    SQLException - If the statement is not open or the input value is not valid.
  - setMaxRows
```
public void setMaxRows(int max)
                throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the maximum rows limit. The maximum rows limit is the maximum number of rows that a result set can contain. If the limit is exceeded, the excess rows are dropped.
    
    Specified by:
    
    setMaxRows in interface Statement
    
    Overrides:
    
    setMaxRows in class AS400JDBCStatement
    
    Parameters:
    
    max - The maximum rows limit or 0 for no limit. The default is 0.
    
    Throws:
    
    SQLException - If the statement is not open or the input value is not valid.
  - setQueryTimeout
```
public void setQueryTimeout(int seconds)
                     throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the query timeout limit. The query timeout limit is the number of seconds that the driver will wait for a SQL statement to execute.
    This is implemented using the database query time limit, also known as QQRYTIMLMT. This value specifies the query processing time limit that is compared to the estimated number of elapsed seconds that a query must run. The time limit determines if the database query can start.
    Beginning with Version 6 Release 1 of IBM i, you must have *JOBCTL special authority.
    
    Specified by:
    
    setQueryTimeout in interface Statement
    
    Overrides:
    
    setQueryTimeout in class AS400JDBCStatement
    
    Parameters:
    
    seconds - The query timeout limit (in seconds) or 0 for no limit. The default is the job's query timeout limit value unless this method is explicitly called.
    
    Throws:
    
    SQLException - If the statement is not open or the input value is not valid.
  - toString
```
public String toString()
```
    Description copied from class: AS400JDBCStatement
    
    Returns the statement name.
    
    Overrides:
    
    toString in class AS400JDBCStatement
    
    Returns:
    
    The statement name.
  - setPoolable
```
public void setPoolable(boolean poolable)
                 throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Requests that a Statement be pooled or not pooled. The value specified is a hint to the statement pool implementation indicating whether the applicaiton wants the statement to be pooled. It is up to the statement pool manager as to whether the hint is used.
    The poolable value of a statement is applicable to both internal statement caches implemented by the driver and external statement caches implemented by application servers and other applications.
    By default, a Statement is poolable when it is created.
    
    Specified by:
    
    setPoolable in interface Statement
    
    Overrides:
    
    setPoolable in class AS400JDBCStatement
    
    Parameters:
    
    poolable - requests that the statement be pooled if true and that the statement not be pooled if false
    
    Throws:
    
    SQLException - if the Statement has been closed
  - isPoolable
```
public boolean isPoolable()
                   throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns the value of the statements poolable hint, indicating whether pooling of the statement is requested.
    
    Specified by:
    
    isPoolable in interface Statement
    
    Overrides:
    
    isPoolable in class AS400JDBCStatement
    
    Returns:
    
    The value of the statements poolable hint.
    
    Throws:
    
    SQLException - if the Statement has been closed
    see java.sql.Statement#setPoolable(boolean) setPoolable(boolean)
  - getValidWrappedList
```
protected String[] getValidWrappedList()
```
    Overrides:
    
    getValidWrappedList in class AS400JDBCPreparedStatement
  - closeOnCompletion
```
public void closeOnCompletion()
                       throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Specifies that this Statement will be closed when all its dependent result sets are closed. If execution of the Statement does not produce any result sets, this method has no effect.
    Note: Multiple calls to closeOnCompletion do not toggle the effect on this Statement. However, a call to closeOnCompletion does effect both the subsequent execution of statements, and statements that currently have open, dependent, result sets.
    
    Specified by:
    
    closeOnCompletion in interface Statement
    
    Overrides:
    
    closeOnCompletion in class AS400JDBCStatement
    
    Throws:
    
    SQLException - - if this method is called on a closed Statement
  - isCloseOnCompletion
```
public boolean isCloseOnCompletion()
                            throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Returns a value indicating whether this Statement will be closed when all its dependent result sets are closed.
    
    Specified by:
    
    isCloseOnCompletion in interface Statement
    
    Overrides:
    
    isCloseOnCompletion in class AS400JDBCStatement
    
    Returns:
    
    true if the Statement will be closed when all of its dependent result sets are closed; false otherwise
    
    Throws:
    
    SQLException - - if this method is called on a closed Statement
  - startCancelThread
```
protected void startCancelThread()
```
    Description copied from class: AS400JDBCStatement
    
    Handles the work involved in supporting a setQueryTimeout option with the cancel property set. .
    
    Overrides:
    
    startCancelThread in class AS400JDBCStatement
  - endCancelThread
```
protected void endCancelThread()
```
    Description copied from class: AS400JDBCStatement
    
    endTheCancelThread
    
    Overrides:
    
    endCancelThread in class AS400JDBCStatement
  - getLargeUpdateCount
```
public long getLargeUpdateCount()
                         throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned. This method should be called only once per result.
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    
    Specified by:
    
    getLargeUpdateCount in interface Statement
    
    Overrides:
    
    getLargeUpdateCount in class AS400JDBCStatement
    
    Returns:
    
    the current result as an update count; -1 if the current result is a ResultSet object or there are no more results
    
    Throws:
    
    SQLException - - if a database access error occurs or this method is called on a closed Statement
  - setLargeMaxRows
```
public void setLargeMaxRows(long max)
                     throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped.
    This method should be used when the row limit may exceed Integer.MAX_VALUE.
    
    Specified by:
    
    setLargeMaxRows in interface Statement
    
    Overrides:
    
    setLargeMaxRows in class AS400JDBCStatement
    
    Parameters:
    
    max - the new max rows limit; zero means there is no limit
    
    Throws:
    
    SQLException - - if a database access error occurs, this method is called on a closed Statement or the condition max >= 0 is not satisfied
  - getLargeMaxRows
```
public long getLargeMaxRows()
                     throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain. If this limit is exceeded, the excess rows are silently dropped.
    This method should be used when the returned row limit may exceed Integer.MAX_VALUE.
    
    Specified by:
    
    getLargeMaxRows in interface Statement
    
    Overrides:
    
    getLargeMaxRows in class AS400JDBCStatement
    
    Returns:
    
    the current maximum number of rows for a ResultSet object produced by this means there is no limit
    
    Throws:
    
    SQLException - -if a database access error occurs or this method is called on a closed Statement
  - executeLargeBatch
```
public long[] executeLargeBatch()
                         throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The long elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch. The elements in the array returned by the method executeLargeBatch may be one of the following:
    A number greater than or equal to zero -- indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution
    A value of SUCCESS_NO_INFO -- indicates that the command was processed successfully but that the number of rows affected is unknown.
    If one of the commands in a batch update fails to execute properly, this method throws a BatchUpdateException, and a JDBC driver may or may not continue to process the remaining commands in the batch. However, the driver's behavior must be consistent with a particular DBMS, either always continuing to process commands or never continuing to process commands. If the driver continues processing after a failure, the array returned by the method BatchUpdateException.getLargeUpdateCounts will contain as many elements as there are commands in the batch, and at least one of the elements will be the following:
    A value of EXECUTE_FAILED -- indicates that the command failed to execute successfully and occurs only if a driver continues to process commands after a command fails
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    
    Specified by:
    
    executeLargeBatch in interface Statement
    
    Overrides:
    
    executeLargeBatch in class AS400JDBCStatement
    
    Returns:
    
    an array of update counts containing one element for each command in the batch. The elements of the array are ordered according to the order in which commands were added to the batch.
    
    Throws:
    
    SQLException - - if a database access error occurs, this method is called on a closed Statement or the driver does not support batch statements. Throws BatchUpdateException (a subclass of SQLException) if one of the commands sent to the database fails to execute properly or attempts to return a result set.
  - executeLargeUpdate
```
public long executeLargeUpdate(String sql)
                        throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    Note:This method cannot be called on a PreparedStatement or CallableStatement.
    
    Specified by:
    
    executeLargeUpdate in interface Statement
    
    Overrides:
    
    executeLargeUpdate in class AS400JDBCStatement
    
    Parameters:
    
    sql - an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    
    Returns:
    
    either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
    
    Throws:
    
    SQLException - - if a database access error occurs, this method is called on a closed Statement, the given SQL statement produces a ResultSet object, the method is called on a PreparedStatement or CallableStatement.
  - executeLargeUpdate
```
public long executeLargeUpdate(String sql,
                               int autoGeneratedKeys)
                        throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval. The driver will ignore the flag if the SQL statement is not an INSERT statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    
    Specified by:
    
    executeLargeUpdate in interface Statement
    
    Overrides:
    
    executeLargeUpdate in class AS400JDBCStatement
    
    Parameters:
    
    sql - - an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    
    autoGeneratedKeys - - a flag indicating whether auto-generated keys should be made available for retrieval; one of the following constants: Statement.RETURN_GENERATED_KEYS Statement.NO_GENERATED_KEYS
    
    Returns:
    
    either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
    
    Throws:
    
    SQLException - - if a database access error occurs, this method is called on a closed Statement, the given SQL statement returns a ResultSet object, the given constant is not one of those allowed, the method is called on a PreparedStatement or CallableStatement
  - executeLargeUpdate
```
public long executeLargeUpdate(String sql,
                               int[] columnIndexes)
                        throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not an INSERT statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    Note:This method cannot be called on a PreparedStatement or CallableStatement.
    
    Specified by:
    
    executeLargeUpdate in interface Statement
    
    Overrides:
    
    executeLargeUpdate in class AS400JDBCStatement
    
    Parameters:
    
    sql - - an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    
    columnIndexes - - an array of column indexes indicating the columns that should be returned from the inserted row
    
    Returns:
    
    either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
    
    Throws:
    
    SQLException - - if a database access error occurs, this method is called on a closed Statement, the SQL statement returns a ResultSet object,the second argument supplied to this method is not an int array whose elements are valid column indexes, the method is called on a PreparedStatement or CallableStatement
  - executeLargeUpdate
```
public long executeLargeUpdate(String sql,
                               String[] columnNames)
                        throws SQLException
```
    Description copied from class: AS400JDBCStatement
    
    Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. This array contains the names of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not an INSERT statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    Note:This method cannot be called on a PreparedStatement or CallableStatement.
    
    Specified by:
    
    executeLargeUpdate in interface Statement
    
    Overrides:
    
    executeLargeUpdate in class AS400JDBCStatement
    
    Parameters:
    
    sql - - an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    
    columnNames - - an array of the names of the columns that should be returned from the inserted row
    
    Returns:
    
    either the row count for INSERT, UPDATE, or DELETE statements, or 0 for SQL statements that return nothing
    
    Throws:
    
    SQLException - if a database access error occurs, this method is called on a closed Statement, the SQL statement returns a ResultSet object, the second argument supplied to this method is not a String array whose elements are valid column names, the method is called on a PreparedStatement or CallableStatement
  - executeQuery
```
public ResultSet executeQuery()
                       throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs the SQL statement that returns a single result set. This closes the current result set and clears warnings before executing the SQL statement again.
    
    Specified by:
    
    executeQuery in interface PreparedStatement
    
    Specified by:
    
    executeQuery in class AS400JDBCPreparedStatement
    
    Returns:
    
    The result set that contains the data produced by the query.
    
    Throws:
    
    SQLException - If the statement is not open, no result set is returned by the database, the query timeout limit is exceeded, an input parameter has not been set, or an error occurs.
  - executeUpdate
```
public int executeUpdate()
                  throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set. This closes the current result set and clears warnings before executing the SQL statement again.
    
    Specified by:
    
    executeUpdate in interface PreparedStatement
    
    Specified by:
    
    executeUpdate in class AS400JDBCPreparedStatement
    
    Returns:
    
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    SQLException - If the statement is not open, the query timeout limit is exceeded, the statement returns a result set, an input parameter has not been set, or an error occurs.
  - setNull
```
public void setNull(int parameterIndex,
                    int sqlType)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to SQL NULL.
    
    Specified by:
    
    setNull in interface PreparedStatement
    
    Specified by:
    
    setNull in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    sqlType - The SQL type code defined in java.sql.Types.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the SQL type is not valid.
  - setBoolean
```
public void setBoolean(int parameterIndex,
                       boolean x)
                throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java boolean value. The driver converts this to an SQL SMALLINT value.
    
    Specified by:
    
    setBoolean in interface PreparedStatement
    
    Specified by:
    
    setBoolean in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setByte
```
public void setByte(int parameterIndex,
                    byte x)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java byte value. The driver converts this to an SQL SMALLINT value.
    
    Specified by:
    
    setByte in interface PreparedStatement
    
    Specified by:
    
    setByte in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setShort
```
public void setShort(int parameterIndex,
                     short x)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java short value. The driver converts this to an SQL SMALLINT value.
    
    Specified by:
    
    setShort in interface PreparedStatement
    
    Specified by:
    
    setShort in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid or the parameter is not an input parameter.
  - setInt
```
public void setInt(int parameterIndex,
                   int x)
            throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java int value. The driver converts this to an SQL INTEGER value.
    
    Specified by:
    
    setInt in interface PreparedStatement
    
    Specified by:
    
    setInt in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid or the parameter is not an input parameter.
  - setLong
```
public void setLong(int parameterIndex,
                    long x)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java long value. If the connected system supports SQL BIGINT data, the driver converts this to an SQL BIGINT value. Otherwise, the driver converts this to an SQL INTEGER value. SQL BIGINT data is supported on V4R5 and later.
    
    Specified by:
    
    setLong in interface PreparedStatement
    
    Specified by:
    
    setLong in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setFloat
```
public void setFloat(int parameterIndex,
                     float x)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java float value. The driver converts this to an SQL REAL value.
    
    Specified by:
    
    setFloat in interface PreparedStatement
    
    Specified by:
    
    setFloat in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setDouble
```
public void setDouble(int parameterIndex,
                      double x)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java double value. The driver converts this to an SQL DOUBLE value.
    
    Specified by:
    
    setDouble in interface PreparedStatement
    
    Specified by:
    
    setDouble in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid or the parameter is not an input parameter.
  - setBigDecimal
```
public void setBigDecimal(int parameterIndex,
                          BigDecimal x)
                   throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a BigDecimal value. The driver converts this to an SQL NUMERIC value.
    
    Specified by:
    
    setBigDecimal in interface PreparedStatement
    
    Specified by:
    
    setBigDecimal in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setString
```
public void setString(int parameterIndex,
                      String x)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a String value. The driver converts this to an SQL VARCHAR value.
    
    Specified by:
    
    setString in interface PreparedStatement
    
    Specified by:
    
    setString in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setBytes
```
public void setBytes(int parameterIndex,
                     byte[] x)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Java byte array value. The driver converts this to an SQL VARBINARY value.
    
    Specified by:
    
    setBytes in interface PreparedStatement
    
    Specified by:
    
    setBytes in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setDate
```
public void setDate(int parameterIndex,
                    Date x)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a java.sql.Date value using the default calendar. The driver converts this to an SQL DATE value.
    
    Specified by:
    
    setDate in interface PreparedStatement
    
    Specified by:
    
    setDate in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setTime
```
public void setTime(int parameterIndex,
                    Time x)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a java.sql.Time value using the default calendar. The driver converts this to an SQL TIME value.
    
    Specified by:
    
    setTime in interface PreparedStatement
    
    Specified by:
    
    setTime in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setTimestamp
```
public void setTimestamp(int parameterIndex,
                         Timestamp x)
                  throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a java.sql.Timestamp value using the default calendar. The driver converts this to an SQL TIMESTAMP value.
    
    Specified by:
    
    setTimestamp in interface PreparedStatement
    
    Specified by:
    
    setTimestamp in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setAsciiStream
```
public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           int length)
                    throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to an ASCII stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARCHAR value.
    
    Specified by:
    
    setAsciiStream in interface PreparedStatement
    
    Specified by:
    
    setAsciiStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    length - The number of bytes in the stream.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the length is not valid, the input stream does not contain all ASCII characters, or an error occurs while reading the input stream.
  - setUnicodeStream
```
public void setUnicodeStream(int parameterIndex,
                             InputStream x,
                             int length)
                      throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Unicode stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARCHAR value.
    Note that the number of bytes in a Unicode stream can be computed as 2 multiplied by the number of characters plus 2 bytes for the byte-order mark. If an uneven number of bytes is specified, then Java will convert this to an empty String.
    
    Specified by:
    
    setUnicodeStream in interface PreparedStatement
    
    Specified by:
    
    setUnicodeStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    length - The number of bytes in the stream.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the length is not valid, the input stream does not contain all Unicode characters, or an error occurs while reading the input stream
    
    See Also:
    
    AS400JDBCPreparedStatement.setCharacterStream(int, java.io.Reader, int)
  - setBinaryStream
```
public void setBinaryStream(int parameterIndex,
                            InputStream stream,
                            int length)
                     throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a binary stream value. The driver reads the data from the stream as needed until no more bytes are available. The driver converts this to an SQL VARBINARY value.
    If a parameter is set using setBinaryStream, then the parameter must be reset prior to the second execute of the PreparedStatement object.
    
    Specified by:
    
    setBinaryStream in interface PreparedStatement
    
    Specified by:
    
    setBinaryStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - The parameter value or null to set the value to SQL NULL.
    
    length - The number of bytes in the stream.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the length is not valid, or an error occurs while reading the input stream.
  - clearParameters
```
public void clearParameters()
                     throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Releases the resources used by the current input parameter values. In general, input parameter values remain in effect for repeated executions of the prepared statement. Setting an input parameter value to a new value automatically clears its previous value.
    
    Specified by:
    
    clearParameters in interface PreparedStatement
    
    Specified by:
    
    clearParameters in class AS400JDBCPreparedStatement
    
    Throws:
    
    SQLException - If the statement is not open.
  - setObject
```
public void setObject(int parameterIndex,
                      Object x,
                      int targetSqlType,
                      int scale)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to an Object value. The driver converts this to a value with the specified SQL type.
    If proxy support is in use, the Object must be serializable.
    
    Specified by:
    
    setObject in interface PreparedStatement
    
    Specified by:
    
    setObject in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    targetSqlType - The SQL type code defined in java.sql.Types.
    
    scale - The number of digits after the decimal if sqlType is DECIMAL or NUMERIC.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the SQL type is not valid, the scale is not valid, or the parameter is not serializable (when proxy support is in use).
  - setObject
```
public void setObject(int parameterIndex,
                      Object x,
                      int targetSqlType)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to an Object value. The driver converts this to a value with the specified SQL type.
    If proxy support is in use, the Object must be serializable.
    
    Specified by:
    
    setObject in interface PreparedStatement
    
    Specified by:
    
    setObject in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    targetSqlType - The SQL type code defined in java.sql.Types.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the SQL type is not valid, or the parameter is not serializable (when proxy support is in use).
  - setObject
```
public void setObject(int parameterIndex,
                      Object x)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to an Object value. The driver converts this to a value of an SQL type, depending on the type of the specified value. The JDBC specification defines a standard mapping from Java types to SQL types. In the cases where a SQL type is not supported by DB2 for IBM i, the next closest matching type is used.
    If proxy support is in use, the Object must be serializable.
    
    Specified by:
    
    setObject in interface PreparedStatement
    
    Specified by:
    
    setObject in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the type of value is not supported, or the parameter is not serializable (when proxy support is in use).
  - execute
```
public boolean execute()
                throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Runs an SQL statement that may return multiple result sets. This closes the current result set and clears warnings before executing the SQL statement again.
    Under some situations, a single SQL statement may return multiple result sets, an update count, or both. This might occur either when executing a stored procedure that returns multiple result sets or when dynamically executing an unknown SQL string.
    Use Statement.getMoreResults(), Statement.getResultSet(), and Statement.getUpdateCount() to navigate through multiple result sets, an update count, or both.
    
    Specified by:
    
    execute in interface PreparedStatement
    
    Specified by:
    
    execute in class AS400JDBCPreparedStatement
    
    Returns:
    
    true if a result set was returned; false if an update count was returned or nothing was returned.
    
    Throws:
    
    SQLException - If the statement is not open, the query timeout limit is exceeded, or an error occurs.
  - addBatch
```
public void addBatch()
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Adds the set of parameters to the current batch.
    
    Specified by:
    
    addBatch in interface PreparedStatement
    
    Specified by:
    
    addBatch in class AS400JDBCPreparedStatement
    
    Throws:
    
    SQLException - If the statement is not open or an input parameter has not been set.
  - setCharacterStream
```
public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               int length)
                        throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a character stream value. The driver reads the data from the character stream as needed until no more characters are available. The driver converts this to an SQL VARCHAR value.
    
    Specified by:
    
    setCharacterStream in interface PreparedStatement
    
    Specified by:
    
    setCharacterStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - The parameter value or null to set the value to SQL NULL.
    
    length - The number of characters to read from the reader.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, the length is not valid, or an error occurs while reading the character stream
  - setRef
```
public void setRef(int parameterIndex,
                   Ref x)
            throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Ref value. DB2 for IBM i does not support structured types.
    
    Specified by:
    
    setRef in interface PreparedStatement
    
    Specified by:
    
    setRef in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - Always thrown because DB2 for IBM i does not support structured types.
  - setBlob
```
public void setBlob(int parameterIndex,
                    Blob x)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Blob value. The driver converts this to an SQL BLOB value.
    If proxy support is in use, the Blob must be serializable.
    
    Specified by:
    
    setBlob in interface PreparedStatement
    
    Specified by:
    
    setBlob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the parameter is not serializable (when proxy support is in use).
  - setClob
```
public void setClob(int parameterIndex,
                    Clob x)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a Clob value. The driver converts this to an SQL CLOB value.
    If proxy support is in use, the Clob must be serializable.
    
    Specified by:
    
    setClob in interface PreparedStatement
    
    Specified by:
    
    setClob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the parameter is not serializable (when proxy support is in use).
  - setArray
```
public void setArray(int parameterIndex,
                     Array x)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to an Array value. DB2 for IBM i only supports arrays in stored procedures.
    
    Specified by:
    
    setArray in interface PreparedStatement
    
    Specified by:
    
    setArray in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value.
    
    Throws:
    
    SQLException - Always thrown because DB2 for IBM i does not support arrays.
  - getMetaData
```
public ResultSetMetaData getMetaData()
                              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    Returns the ResultSetMetaData object that describes the result set's columns. Null is returned if the statement does not return a result set. In the following example rsmd is null since the statement does not return a result set.
```
 PreparedStatement ps = connection
     .prepareStatement("INSERT INTO COLLECTION.TABLE VALUES(?)");
 ResultSetMetaData rsmd = ps.getMetaData();
 
```
    Specified by:
    
    getMetaData in interface PreparedStatement
    
    Specified by:
    
    getMetaData in class AS400JDBCPreparedStatement
    
    Returns:
    
    The metadata object, or null if the statement does not return a result set.
    
    Throws:
    
    SQLException - If the statement is not open.
  - setDate
```
public void setDate(int parameterIndex,
                    Date x,
                    Calendar cal)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a java.sql.Date value using a calendar other than the default. The driver converts this to an SQL DATE value.
    
    Specified by:
    
    setDate in interface PreparedStatement
    
    Specified by:
    
    setDate in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    cal - The calendar.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the calendar is null.
  - setTime
```
public void setTime(int parameterIndex,
                    Time x,
                    Calendar cal)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a java.sql.Time value using a calendar other than the default. The driver converts this to an SQL TIME value.
    
    Specified by:
    
    setTime in interface PreparedStatement
    
    Specified by:
    
    setTime in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    cal - The calendar.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the calendar is null.
  - setTimestamp
```
public void setTimestamp(int parameterIndex,
                         Timestamp x,
                         Calendar cal)
                  throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a java.sql.Timestamp value using a calendar other than the default. The driver converts this to an SQL TIMESTAMP value.
    
    Specified by:
    
    setTimestamp in interface PreparedStatement
    
    Specified by:
    
    setTimestamp in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    cal - The calendar.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the calendar is null.
  - setNull
```
public void setNull(int parameterIndex,
                    int sqlType,
                    String typeName)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to SQL NULL.
    
    Specified by:
    
    setNull in interface PreparedStatement
    
    Specified by:
    
    setNull in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    sqlType - The SQL type code defined in java.sql.Types.
    
    typeName - The fully-qualified name of an SQL structured type. This value will be ignored.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the SQL type is not valid.
  - setURL
```
public void setURL(int parameterIndex,
                   URL x)
            throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to a URL value. The driver converts this to an SQL DATALINK value.
    
    Specified by:
    
    setURL in interface PreparedStatement
    
    Specified by:
    
    setURL in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - getParameterMetaData
```
public ParameterMetaData getParameterMetaData()
                                       throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Returns the number, types, and properties of a PreparedStatement object's parameters.
    
    Specified by:
    
    getParameterMetaData in interface PreparedStatement
    
    Specified by:
    
    getParameterMetaData in class AS400JDBCPreparedStatement
    
    Returns:
    
    The ParameterMetaData object that describes this prepared statement object.
    
    Throws:
    
    SQLException - If the statement is not open.
  - setNClob
```
public void setNClob(int parameterIndex,
                     Reader reader)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB
    Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNClob which takes a length parameter.
    
    Specified by:
    
    setNClob in interface PreparedStatement
    
    Specified by:
    
    setNClob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
  - setAsciiStream
```
public void setAsciiStream(int parameterIndex,
                           InputStream stream)
                    throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given input stream. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    
    Specified by:
    
    setAsciiStream in interface PreparedStatement
    
    Specified by:
    
    setAsciiStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - the Java input stream that contains the ASCII parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
  - setAsciiStream
```
public void setAsciiStream(int parameterIndex,
                           InputStream stream,
                           long length)
                    throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    
    Specified by:
    
    setAsciiStream in interface PreparedStatement
    
    Specified by:
    
    setAsciiStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - the Java input stream that contains the ASCII parameter value
    
    length - the number of bytes in the stream
    
    Throws:
    
    SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
  - setBinaryStream
```
public void setBinaryStream(int parameterIndex,
                            InputStream stream)
                     throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given input stream. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    
    Specified by:
    
    setBinaryStream in interface PreparedStatement
    
    Specified by:
    
    setBinaryStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - the java input stream which contains the binary parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
  - setBinaryStream
```
public void setBinaryStream(int parameterIndex,
                            InputStream stream,
                            long length)
                     throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    
    Specified by:
    
    setBinaryStream in interface PreparedStatement
    
    Specified by:
    
    setBinaryStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - the java input stream which contains the binary parameter value
    
    length - the number of bytes in the stream
    
    Throws:
    
    SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
  - setBlob
```
public void setBlob(int parameterIndex,
                    InputStream stream)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a InputStream object. This method differs from the setBinaryStream (int, InputStream) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB
    
    Specified by:
    
    setBlob in interface PreparedStatement
    
    Specified by:
    
    setBlob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement or if parameterIndex does not correspond to a parameter marker in the SQL statement,
  - setBlob
```
public void setBlob(int parameterIndex,
                    InputStream stream,
                    long length)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to an InputStream object. The inputStream must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed.
    
    Specified by:
    
    setBlob in interface PreparedStatement
    
    Specified by:
    
    setBlob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    stream - An object that contains the data to set the parameter value to.
    
    length - the number of bytes in the parameter data.
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement, if the length specified is less than zero or if the number of bytes in the inputstream does not match the specfied length.
  - setCharacterStream
```
public void setCharacterStream(int parameterIndex,
                               Reader reader)
                        throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setCharacterStream which takes a length parameter.
    
    Specified by:
    
    setCharacterStream in interface PreparedStatement
    
    Specified by:
    
    setCharacterStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - the java.io.Reader object that contains the Unicode data
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
  - setCharacterStream
```
public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               long length)
                        throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    
    Specified by:
    
    setCharacterStream in interface PreparedStatement
    
    Specified by:
    
    setCharacterStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - the java.io.Reader object that contains the Unicode data
    
    length - the number of characters in the stream
    
    Throws:
    
    SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
  - setClob
```
public void setClob(int parameterIndex,
                    Reader reader)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR or a CLOB
    Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setClob which takes a length parameter.
    
    Specified by:
    
    setClob in interface PreparedStatement
    
    Specified by:
    
    setClob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatementor if parameterIndex does not correspond to a parameter marker in the SQL statement
  - setClob
```
public void setClob(int parameterIndex,
                    Reader reader,
                    long length)
             throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed.
    
    Specified by:
    
    setClob in interface PreparedStatement
    
    Specified by:
    
    setClob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - An object that contains the data to set the parameter value to.
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement, or if the length specified is less than zero.
  - setNCharacterStream
```
public void setNCharacterStream(int parameterIndex,
                                Reader reader)
                         throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a Reader object. The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.
    Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
    Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNCharacterStream which takes a length parameter.
    
    Specified by:
    
    setNCharacterStream in interface PreparedStatement
    
    Specified by:
    
    setNCharacterStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - the parameter value
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement
  - setNCharacterStream
```
public void setNCharacterStream(int parameterIndex,
                                Reader reader,
                                long length)
                         throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a Reader object. The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.
    
    Specified by:
    
    setNCharacterStream in interface PreparedStatement
    
    Specified by:
    
    setNCharacterStream in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - the parameter value
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - If a database error occurs. if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs
  - setNClob
```
public void setNClob(int parameterIndex,
                     Reader reader,
                     long length)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed.
    
    Specified by:
    
    setNClob in interface PreparedStatement
    
    Specified by:
    
    setNClob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    reader - An object that contains the data to set the parameter value to.
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - If a database error occurs. if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs
  - setNString
```
public void setNString(int parameterIndex,
                       String x)
                throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated paramter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values) when it sends it to the database.
    
    Specified by:
    
    setNString in interface PreparedStatement
    
    Specified by:
    
    setNString in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - the parameter value
    
    Throws:
    
    SQLException - If a database error occurs. if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs
  - setDB2Default
```
public void setDB2Default(int parameterIndex)
                   throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to the default value
    
    Specified by:
    
    setDB2Default in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDBDefault
```
public void setDBDefault(int parameterIndex)
                  throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to the default value. This is a the same as setDB2Default.
    
    Specified by:
    
    setDBDefault in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDB2Unassigned
```
public void setDB2Unassigned(int parameterIndex)
                      throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to unassigned
    
    Specified by:
    
    setDB2Unassigned in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDBUnassigned
```
public void setDBUnassigned(int parameterIndex)
                     throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets an input parameter to unassigned. This is a the same as setDB2Unassigned.
    
    Specified by:
    
    setDBUnassigned in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - getDB2ParameterName
```
public String getDB2ParameterName(int parm)
                           throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Return the name of the parameter for a stored procedure call.
    
    Specified by:
    
    getDB2ParameterName in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parm - the parameter number to get the name for
    
    Returns:
    
    the parameter name.
    
    Throws:
    
    SQLException - If a database error occurs.
  - setObject
```
public void setObject(int parameterIndex,
                      Object x,
                      SQLType targetSqlType,
                      int scaleOrLength)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the value of the designated parameter with the given object. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLException when the prepared statement is executed.
    The given Java object will be converted to the given targetSqlType before being sent to the database. If the object has a custom mapping (is of a class implementing the interface SQLData), the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, NClob, Struct, java.net.URL, or Array, the driver should pass it to the database as a value of the corresponding SQL type.
    Note that this method may be used to pass database-specific abstract data types.
    
    Specified by:
    
    setObject in interface PreparedStatement
    
    Specified by:
    
    setObject in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - - the first parameter is 1, the second is 2, ...
    
    x - - the object containing the input parameter value
    
    targetSqlType - - the SQL type to be sent to the database. The scale argument may further qualify this type.
    
    scaleOrLength - - for java.sql.JDBCType.DECIMAL or java.sql.JDBCType.NUMERIC types, this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
    
    Throws:
    
    SQLException - - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement or if the Java Object specified by x is an InputStream or Reader object and the value of the scale parameter is less than zero
  - setObject
```
public void setObject(int parameterIndex,
                      Object x,
                      SQLType targetSqlType)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the value of the designated parameter with the given object. This method is similar to setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength), except that it assumes a scale of zero.
    
    Specified by:
    
    setObject in interface PreparedStatement
    
    Specified by:
    
    setObject in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - - the first parameter is 1, the second is 2, ...
    
    x - - the object containing the input parameter value
    
    targetSqlType - - the SQL type to be sent to the database parameterIndex
    
    Throws:
    
    SQLException - - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
  - executeLargeUpdate
```
public long executeLargeUpdate()
                        throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
    This method should be used when the returned row count may exceed Integer.MAX_VALUE.
    
    Specified by:
    
    executeLargeUpdate in interface PreparedStatement
    
    Specified by:
    
    executeLargeUpdate in class AS400JDBCPreparedStatement
    
    Returns:
    
    either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
    
    Throws:
    
    SQLException - - if a database access error occurs; this method is called on a closed PreparedStatement or the SQL statement returns a ResultSet object
  - setNClob
```
public void setNClob(int parameterIndex,
                     NClob clob)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to a java.sql.NClob object. The driver converts this to a SQL NCLOB value when it sends it to the database.
    
    Specified by:
    
    setNClob in interface PreparedStatement
    
    Specified by:
    
    setNClob in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    clob - the parameter value
    
    Throws:
    
    SQLException - if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs
  - setSQLXML
```
public void setSQLXML(int parameterIndex,
                      SQLXML xml)
               throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given java.sql.SQLXML object.
    
    Specified by:
    
    setSQLXML in interface PreparedStatement
    
    Specified by:
    
    setSQLXML in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    xml - a SQLXML object that maps an SQL XML value
    
    Throws:
    
    SQLException - if a database access error occurs
  - setRowId
```
public void setRowId(int parameterIndex,
                     RowId x)
              throws SQLException
```
    Description copied from class: AS400JDBCPreparedStatement
    
    Sets the designated parameter to the given java.sql.RowId object. The driver converts this to a SQL ROWID value when it sends it to the database
    
    Specified by:
    
    setRowId in interface PreparedStatement
    
    Specified by:
    
    setRowId in class AS400JDBCPreparedStatement
    
    Parameters:
    
    parameterIndex - The parameter index (1-based).
    
    x - the parameter value
    
    Throws:
    
    SQLException - if a database access error occurs
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.
    
    Specified by:
    
    isWrapperFor in interface Wrapper
    
    Parameters:
    
    iface - a Class defining an interface.
    
    Returns:
    
    true if this implements the interface or directly or indirectly wraps an object that does.
    
    Throws:
    
    SQLException - If a database error occurs. if an error occurs while determining whether this is a wrapper for an object with the given interface.
  - unwrap
```
public <T> T unwrap(Class<T> iface)
             throws SQLException
```
    Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.
    
    Specified by:
    
    unwrap in interface Wrapper
    
    Parameters:
    
    iface - A Class defining an interface that the result must implement.
    
    Returns:
    
    an object that implements the interface. May be a proxy for the actual implementing object.
    
    Throws:
    
    SQLException - If a database error occurs. If no object found that implements the interface

Class AS400JDBCPreparedStatementRedirect

Field Summary

Fields inherited from class com.ibm.as400.access.AS400JDBCStatement

Fields inherited from interface java.sql.Statement

Method Summary

Methods inherited from class com.ibm.as400.access.AS400JDBCStatement

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

Method Detail

addBatch

cancel

clearBatch

clearWarnings

close

execute

execute

execute

execute

executeBatch

executeQuery

executeUpdate

executeUpdate

executeUpdate

executeUpdate

getConnection

getFetchDirection

getFetchSize

getGeneratedKeys

getMaxFieldSize

getMaxRows

getMoreResults

getMoreResults

getPositionOfSyntaxError

getQueryTimeout

getResultSet

getResultSetConcurrency

getResultSetHoldability

getResultSetType

getUpdateCount

getWarnings

isClosed

setCursorName

setEscapeProcessing

setFetchDirection

setFetchSize

setMaxFieldSize

setMaxRows

setQueryTimeout

toString

setPoolable

isPoolable

getValidWrappedList

closeOnCompletion

isCloseOnCompletion

startCancelThread

endCancelThread

getLargeUpdateCount

setLargeMaxRows

getLargeMaxRows

executeLargeBatch

executeLargeUpdate

executeLargeUpdate

executeLargeUpdate

executeLargeUpdate

executeQuery

executeUpdate

setNull

setBoolean

setByte

setShort

setInt

setLong

setFloat

setDouble

setBigDecimal

setString

setBytes

setDate

setTime