AS400JDBCPreparedStatement

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

All Implemented Interfaces:

java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

AS400JDBCPreparedStatementImpl, AS400JDBCPreparedStatementRedirect
```
public abstract class AS400JDBCPreparedStatement
extends AS400JDBCStatement
implements java.sql.PreparedStatement
```
The AS400JDBCPreparedStatement class precompiles and stores an SQL statement. This provides the ability to efficiently run the statement multiple times. In addition, the statement may contain parameters. Use Connection.prepareStatement() to create new PreparedStatement objects.
When setting input parameter values, the caller must specify types that are compatible with the defined SQL type of the input parameter. For example, if the input parameter has SQL type INTEGER, then the caller must call setInt() to set the IN parameter value. If arbitrary type conversions are required, then use setObject() with a target SQL type.
For method that sets parameters, the application should not modify the parameter value until after the execute completes. Modifying a value between the setXXXX method and the execute method may result in unpredictable behavior.

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

Methods
Modifier and Type	Method and Description
`abstract void`	`addBatch()` Adds the set of parameters to the current batch.
`abstract void`	`addBatch(java.lang.String sql)` Adds an SQL statement to the current batch of SQL statements.
`abstract void`	`clearParameters()` Releases the resources used by the current input parameter values.
`abstract boolean`	`execute()` Runs an SQL statement that may return multiple result sets.
`abstract boolean`	`execute(java.lang.String sql)` Runs an SQL statement that may return multiple result sets.
`abstract boolean`	`execute(java.lang.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().
`abstract int[]`	`executeBatch()` Runs the batch of SQL statements.
`abstract 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.
`abstract java.sql.ResultSet`	`executeQuery()` Runs the SQL statement that returns a single result set.
`abstract java.sql.ResultSet`	`executeQuery(java.lang.String sql)` Runs an SQL statement that returns a single result set.
`abstract int`	`executeUpdate()` Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set.
`abstract int`	`executeUpdate(java.lang.String sql)` Runs an SQL INSERT, UPDATE, or DELETE statement, or any SQL statement that does not return a result set.
`abstract int`	`executeUpdate(java.lang.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().
`abstract java.lang.String`	`getDB2ParameterName(int parm)` Return the name of the parameter for a stored procedure call.
`abstract java.sql.ResultSetMetaData`	`getMetaData()` Returns the ResultSetMetaData object that describes the result set's columns.
`abstract java.sql.ParameterMetaData`	`getParameterMetaData()` Returns the number, types, and properties of a PreparedStatement object's parameters.
`protected java.lang.String[]`	`getValidWrappedList()`
`abstract void`	`setArray(int parameterIndex, java.sql.Array parameterValue)` Sets an input parameter to an Array value.
`abstract void`	`setAsciiStream(int parameterIndex, java.io.InputStream x)` Sets the designated parameter to the given input stream.
`abstract void`	`setAsciiStream(int parameterIndex, java.io.InputStream parameterValue, int length)` Sets an input parameter to an ASCII stream value.
`abstract void`	`setAsciiStream(int parameterIndex, java.io.InputStream x, long length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`abstract void`	`setBigDecimal(int parameterIndex, java.math.BigDecimal parameterValue)` Sets an input parameter to a BigDecimal value.
`abstract void`	`setBinaryStream(int parameterIndex, java.io.InputStream x)` Sets the designated parameter to the given input stream.
`abstract void`	`setBinaryStream(int parameterIndex, java.io.InputStream parameterValue, int length)` Sets an input parameter to a binary stream value.
`abstract void`	`setBinaryStream(int parameterIndex, java.io.InputStream x, long length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`abstract void`	`setBlob(int parameterIndex, java.sql.Blob parameterValue)` Sets an input parameter to a Blob value.
`abstract void`	`setBlob(int parameterIndex, java.io.InputStream inputStream)` Sets the designated parameter to a `InputStream` object.
`abstract void`	`setBlob(int parameterIndex, java.io.InputStream inputStream, long length)` Sets the designated parameter to an `InputStream` object.
`abstract void`	`setBoolean(int parameterIndex, boolean parameterValue)` Sets an input parameter to a Java boolean value.
`abstract void`	`setByte(int parameterIndex, byte parameterValue)` Sets an input parameter to a Java byte value.
`abstract void`	`setBytes(int parameterIndex, byte[] parameterValue)` Sets an input parameter to a Java byte array value.
`abstract void`	`setCharacterStream(int parameterIndex, java.io.Reader reader)` Sets the designated parameter to the given `Reader` object.
`abstract void`	`setCharacterStream(int parameterIndex, java.io.Reader parameterValue, int length)` Sets an input parameter to a character stream value.
`abstract void`	`setCharacterStream(int parameterIndex, java.io.Reader reader, long length)` Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
`abstract void`	`setClob(int parameterIndex, java.sql.Clob parameterValue)` Sets an input parameter to a Clob value.
`abstract void`	`setClob(int parameterIndex, java.io.Reader reader)` Sets the designated parameter to a `Reader` object.
`abstract void`	`setClob(int parameterIndex, java.io.Reader reader, long length)` Sets the designated parameter to a `Reader` object.
`abstract void`	`setDate(int parameterIndex, java.sql.Date parameterValue)` Sets an input parameter to a java.sql.Date value using the default calendar.
`abstract void`	`setDate(int parameterIndex, java.sql.Date parameterValue, java.util.Calendar calendar)` Sets an input parameter to a java.sql.Date value using a calendar other than the default.
`abstract void`	`setDB2Default(int parameterIndex)` Sets an input parameter to the default value
`abstract void`	`setDB2Unassigned(int parameterIndex)` Sets an input parameter to unassigned
`abstract void`	`setDBDefault(int parameterIndex)` Sets an input parameter to the default value.
`abstract void`	`setDBUnassigned(int parameterIndex)` Sets an input parameter to unassigned.
`abstract void`	`setDouble(int parameterIndex, double parameterValue)` Sets an input parameter to a Java double value.
`abstract void`	`setFloat(int parameterIndex, float parameterValue)` Sets an input parameter to a Java float value.
`abstract void`	`setInt(int parameterIndex, int parameterValue)` Sets an input parameter to a Java int value.
`abstract void`	`setLong(int parameterIndex, long parameterValue)` Sets an input parameter to a Java long value.
`abstract void`	`setNCharacterStream(int parameterIndex, java.io.Reader value)` Sets the designated parameter to a `Reader` object.
`abstract void`	`setNCharacterStream(int parameterIndex, java.io.Reader value, long length)` Sets the designated parameter to a `Reader` object.
`abstract void`	`setNClob(int parameterIndex, java.io.Reader reader)` Sets the designated parameter to a `Reader` object.
`abstract void`	`setNClob(int parameterIndex, java.io.Reader reader, long length)` Sets the designated parameter to a `Reader` object.
`abstract void`	`setNString(int parameterIndex, java.lang.String value)` Sets the designated paramter to the given `String` object.
`abstract void`	`setNull(int parameterIndex, int sqlType)` Sets an input parameter to SQL NULL.
`abstract void`	`setNull(int parameterIndex, int sqlType, java.lang.String typeName)` Sets an input parameter to SQL NULL.
`abstract void`	`setObject(int parameterIndex, java.lang.Object parameterValue)` Sets an input parameter to an Object value.
`abstract void`	`setObject(int parameterIndex, java.lang.Object parameterValue, int sqlType)` Sets an input parameter to an Object value.
`abstract void`	`setObject(int parameterIndex, java.lang.Object parameterValue, int sqlType, int scale)` Sets an input parameter to an Object value.
`abstract void`	`setObject(int parameterIndex, java.lang.Object x, java.lang.Object targetSqlType)` Sets the value of the designated parameter with the given object.
`abstract void`	`setObject(int parameterIndex, java.lang.Object x, java.lang.Object targetSqlType, int scaleOrLength)` Sets the value of the designated parameter with the given object.
`abstract void`	`setRef(int parameterIndex, java.sql.Ref parameterValue)` Sets an input parameter to a Ref value.
`abstract void`	`setShort(int parameterIndex, short parameterValue)` Sets an input parameter to a Java short value.
`abstract void`	`setString(int parameterIndex, java.lang.String parameterValue)` Sets an input parameter to a String value.
`abstract void`	`setTime(int parameterIndex, java.sql.Time parameterValue)` Sets an input parameter to a java.sql.Time value using the default calendar.
`abstract void`	`setTime(int parameterIndex, java.sql.Time parameterValue, java.util.Calendar calendar)` Sets an input parameter to a java.sql.Time value using a calendar other than the default.
`abstract void`	`setTimestamp(int parameterIndex, java.sql.Timestamp parameterValue)` Sets an input parameter to a java.sql.Timestamp value using the default calendar.
`abstract void`	`setTimestamp(int parameterIndex, java.sql.Timestamp parameterValue, java.util.Calendar calendar)` Sets an input parameter to a java.sql.Timestamp value using a calendar other than the default.
`abstract void`	`setUnicodeStream(int parameterIndex, java.io.InputStream parameterValue, int length)` Deprecated. Use setCharacterStream(int, Reader, int) instead.
`abstract void`	`setURL(int parameterIndex, java.net.URL parameterValue)` Sets an input parameter to a URL value.

Methods inherited from class com.ibm.as400.access.AS400JDBCStatement
cancel, clearBatch, clearWarnings, close, closeOnCompletion, endCancelThread, execute, execute, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, finalize, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getPositionOfSyntaxError, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, startCancelThread, toString

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

Methods inherited from interface java.sql.PreparedStatement
setNClob, setRowId, setSQLXML

Methods inherited from interface java.sql.Statement
cancel, clearBatch, clearWarnings, close, execute, execute, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

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

- Method Detail
  - addBatch
```
public abstract void addBatch()
                       throws java.sql.SQLException
```
    Adds the set of parameters to the current batch.
    
    Specified by:
    
    addBatch in interface java.sql.PreparedStatement
    
    Throws:
    
    java.sql.SQLException - If the statement is not open or an input parameter has not been set.
  - addBatch
```
public abstract void addBatch(java.lang.String sql)
                       throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    addBatch in class AS400JDBCStatement
    
    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:
    
    java.sql.SQLException - This exception is always thrown.
  - clearParameters
```
public abstract void clearParameters()
                              throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Throws:
    
    java.sql.SQLException - If the statement is not open.
  - execute
```
public abstract boolean execute()
                         throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Returns:
    true if a result set was returned; false if an update count was returned or nothing was returned.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the query timeout limit is exceeded, or an error occurs.
  - execute
```
public abstract boolean execute(java.lang.String sql)
                         throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    execute in class AS400JDBCStatement
    
    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:
    
    java.sql.SQLException - This exception is always thrown.
  - execute
```
public abstract boolean execute(java.lang.String sql,
              int autoGeneratedKeys)
                         throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    execute in class AS400JDBCStatement
    
    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:
    
    java.sql.SQLException - This exception is always thrown.
    Since:
    
    Modification 5
  - executeBatch
```
public abstract int[] executeBatch()
                            throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    executeBatch in class AS400JDBCStatement
    
    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:
    
    java.sql.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 abstract java.sql.ResultSet executeQuery()
                                         throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Returns:
    The result set that contains the data produced by the query.
    
    Throws:
    
    java.sql.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.
  - executeQuery
```
public abstract java.sql.ResultSet executeQuery(java.lang.String sql)
                                         throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    executeQuery in class AS400JDBCStatement
    
    Parameters:
    sql - The SQL statement.
    
    Returns:
    The result set that contains the data produced by the query.
    
    Throws:
    
    java.sql.SQLException - This exception is always thrown.
  - executeUpdate
```
public abstract int executeUpdate()
                           throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Returns:
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    java.sql.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.
  - executeUpdate
```
public abstract int executeUpdate(java.lang.String sql)
                           throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    executeUpdate in class AS400JDBCStatement
    
    Parameters:
    sql - The SQL statement.
    
    Returns:
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    java.sql.SQLException - This exception is always thrown.
  - executeUpdate
```
public abstract int executeUpdate(java.lang.String sql,
                int autoGeneratedKeys)
                           throws java.sql.SQLException
```
    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 java.sql.Statement
    
    Overrides:
    
    executeUpdate in class AS400JDBCStatement
    
    Parameters:
    sql - The SQL statement.
    
    Returns:
    Either the row count for INSERT, UPDATE, or DELETE, or 0 for SQL statements that return nothing.
    
    Throws:
    
    java.sql.SQLException - This exception is always thrown.
    Since:
    
    Modification 5
  - getMetaData
```
public abstract java.sql.ResultSetMetaData getMetaData()
                                                throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Returns:
    The metadata object, or null if the statement does not return a result set.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open.
  - getParameterMetaData
```
public abstract java.sql.ParameterMetaData getParameterMetaData()
                                                         throws java.sql.SQLException
```
    Returns the number, types, and properties of a PreparedStatement object's parameters.
    
    Specified by:
    
    getParameterMetaData in interface java.sql.PreparedStatement
    
    Returns:
    The ParameterMetaData object that describes this prepared statement object.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open.
    Since:
    
    Modification 5
  - setArray
```
public abstract void setArray(int parameterIndex,
            java.sql.Array parameterValue)
                       throws java.sql.SQLException
```
    Sets an input parameter to an Array value. DB2 for IBM i only supports arrays in stored procedures.
    
    Specified by:
    
    setArray in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - Always thrown because DB2 for IBM i does not support arrays.
  - setAsciiStream
```
public abstract void setAsciiStream(int parameterIndex,
                  java.io.InputStream parameterValue,
                  int length)
                             throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    length - The number of bytes in the stream.
    
    Throws:
    
    java.sql.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.
  - setBigDecimal
```
public abstract void setBigDecimal(int parameterIndex,
                 java.math.BigDecimal parameterValue)
                            throws java.sql.SQLException
```
    Sets an input parameter to a BigDecimal value. The driver converts this to an SQL NUMERIC value.
    
    Specified by:
    
    setBigDecimal in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setBinaryStream
```
public abstract void setBinaryStream(int parameterIndex,
                   java.io.InputStream parameterValue,
                   int length)
                              throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    length - The number of bytes in the stream.
    
    Throws:
    
    java.sql.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.
  - setBlob
```
public abstract void setBlob(int parameterIndex,
           java.sql.Blob parameterValue)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.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).
  - setBoolean
```
public abstract void setBoolean(int parameterIndex,
              boolean parameterValue)
                         throws java.sql.SQLException
```
    Sets an input parameter to a Java boolean value. The driver converts this to an SQL SMALLINT value.
    
    Specified by:
    
    setBoolean in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setByte
```
public abstract void setByte(int parameterIndex,
           byte parameterValue)
                      throws java.sql.SQLException
```
    Sets an input parameter to a Java byte value. The driver converts this to an SQL SMALLINT value.
    
    Specified by:
    
    setByte in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setBytes
```
public abstract void setBytes(int parameterIndex,
            byte[] parameterValue)
                       throws java.sql.SQLException
```
    Sets an input parameter to a Java byte array value. The driver converts this to an SQL VARBINARY value.
    
    Specified by:
    
    setBytes in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setCharacterStream
```
public abstract void setCharacterStream(int parameterIndex,
                      java.io.Reader parameterValue,
                      int length)
                                 throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    length - The number of characters to read from the reader.
    
    Throws:
    
    java.sql.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
  - setClob
```
public abstract void setClob(int parameterIndex,
           java.sql.Clob parameterValue)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.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).
  - setDate
```
public abstract void setDate(int parameterIndex,
           java.sql.Date parameterValue)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setDate
```
public abstract void setDate(int parameterIndex,
           java.sql.Date parameterValue,
           java.util.Calendar calendar)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    calendar - The calendar.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the calendar is null.
  - setDB2Default
```
public abstract void setDB2Default(int parameterIndex)
                            throws java.sql.SQLException
```
    Sets an input parameter to the default value
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDBDefault
```
public abstract void setDBDefault(int parameterIndex)
                           throws java.sql.SQLException
```
    Sets an input parameter to the default value. This is a the same as setDB2Default.
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDB2Unassigned
```
public abstract void setDB2Unassigned(int parameterIndex)
                               throws java.sql.SQLException
```
    Sets an input parameter to unassigned
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDBUnassigned
```
public abstract void setDBUnassigned(int parameterIndex)
                              throws java.sql.SQLException
```
    Sets an input parameter to unassigned. This is a the same as setDB2Unassigned.
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter.
  - setDouble
```
public abstract void setDouble(int parameterIndex,
             double parameterValue)
                        throws java.sql.SQLException
```
    Sets an input parameter to a Java double value. The driver converts this to an SQL DOUBLE value.
    
    Specified by:
    
    setDouble in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid or the parameter is not an input parameter.
  - setFloat
```
public abstract void setFloat(int parameterIndex,
            float parameterValue)
                       throws java.sql.SQLException
```
    Sets an input parameter to a Java float value. The driver converts this to an SQL REAL value.
    
    Specified by:
    
    setFloat in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setInt
```
public abstract void setInt(int parameterIndex,
          int parameterValue)
                     throws java.sql.SQLException
```
    Sets an input parameter to a Java int value. The driver converts this to an SQL INTEGER value.
    
    Specified by:
    
    setInt in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid or the parameter is not an input parameter.
  - setLong
```
public abstract void setLong(int parameterIndex,
           long parameterValue)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setNull
```
public abstract void setNull(int parameterIndex,
           int sqlType)
                      throws java.sql.SQLException
```
    Sets an input parameter to SQL NULL.
    
    Specified by:
    
    setNull in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    sqlType - The SQL type code defined in java.sql.Types.
    
    Throws:
    
    java.sql.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.
  - setNull
```
public abstract void setNull(int parameterIndex,
           int sqlType,
           java.lang.String typeName)
                      throws java.sql.SQLException
```
    Sets an input parameter to SQL NULL.
    
    Specified by:
    
    setNull in interface java.sql.PreparedStatement
    
    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:
    
    java.sql.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.
  - setObject
```
public abstract void setObject(int parameterIndex,
             java.lang.Object parameterValue)
                        throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.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).
  - setObject
```
public abstract void setObject(int parameterIndex,
             java.lang.Object parameterValue,
             int sqlType)
                        throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    sqlType - The SQL type code defined in java.sql.Types.
    
    Throws:
    
    java.sql.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 abstract void setObject(int parameterIndex,
             java.lang.Object parameterValue,
             int sqlType,
             int scale)
                        throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    sqlType - The SQL type code defined in java.sql.Types.
    scale - The number of digits after the decimal if sqlType is DECIMAL or NUMERIC.
    
    Throws:
    
    java.sql.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).
  - setRef
```
public abstract void setRef(int parameterIndex,
          java.sql.Ref parameterValue)
                     throws java.sql.SQLException
```
    Sets an input parameter to a Ref value. DB2 for IBM i does not support structured types.
    
    Specified by:
    
    setRef in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - Always thrown because DB2 for IBM i does not support structured types.
  - setShort
```
public abstract void setShort(int parameterIndex,
            short parameterValue)
                       throws java.sql.SQLException
```
    Sets an input parameter to a Java short value. The driver converts this to an SQL SMALLINT value.
    
    Specified by:
    
    setShort in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid or the parameter is not an input parameter.
  - setString
```
public abstract void setString(int parameterIndex,
             java.lang.String parameterValue)
                        throws java.sql.SQLException
```
    Sets an input parameter to a String value. The driver converts this to an SQL VARCHAR value.
    
    Specified by:
    
    setString in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setTime
```
public abstract void setTime(int parameterIndex,
           java.sql.Time parameterValue)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setTime
```
public abstract void setTime(int parameterIndex,
           java.sql.Time parameterValue,
           java.util.Calendar calendar)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    calendar - The calendar.
    
    Throws:
    
    java.sql.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 abstract void setTimestamp(int parameterIndex,
                java.sql.Timestamp parameterValue)
                           throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
  - setTimestamp
```
public abstract void setTimestamp(int parameterIndex,
                java.sql.Timestamp parameterValue,
                java.util.Calendar calendar)
                           throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    calendar - The calendar.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, the parameter is not an input parameter, or the calendar is null.
  - setUnicodeStream
```
public abstract void setUnicodeStream(int parameterIndex,
                    java.io.InputStream parameterValue,
                    int length)
                               throws java.sql.SQLException
```
    Deprecated. Use setCharacterStream(int, Reader, int) instead.
    
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    length - The number of bytes in the stream.
    
    Throws:
    
    java.sql.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:
    setCharacterStream(int, java.io.Reader, int)
  - setURL
```
public abstract void setURL(int parameterIndex,
          java.net.URL parameterValue)
                     throws java.sql.SQLException
```
    Sets an input parameter to a URL value. The driver converts this to an SQL DATALINK value.
    
    Specified by:
    
    setURL in interface java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    parameterValue - The parameter value or null to set the value to SQL NULL.
    
    Throws:
    
    java.sql.SQLException - If the statement is not open, the index is not valid, or the parameter is not an input parameter.
    Since:
    
    Modification 5
  - setNString
```
public abstract void setNString(int parameterIndex,
              java.lang.String value)
                         throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    value - the parameter value
    
    Throws:
    
    java.sql.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
  - setNCharacterStream
```
public abstract void setNCharacterStream(int parameterIndex,
                       java.io.Reader value,
                       long length)
                                  throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    value - the parameter value
    length - the number of characters in the parameter data.
    
    Throws:
    
    java.sql.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
  - setClob
```
public abstract void setClob(int parameterIndex,
           java.io.Reader reader,
           long length)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    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:
    
    java.sql.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.
  - setBlob
```
public abstract void setBlob(int parameterIndex,
           java.io.InputStream inputStream,
           long length)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    inputStream - An object that contains the data to set the parameter value to.
    length - the number of bytes in the parameter data.
    
    Throws:
    
    java.sql.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.
  - setNClob
```
public abstract void setNClob(int parameterIndex,
            java.io.Reader reader,
            long length)
                       throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    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:
    
    java.sql.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
  - getValidWrappedList
```
protected java.lang.String[] getValidWrappedList()
```
    Overrides:
    
    getValidWrappedList in class AS400JDBCStatement
  - setAsciiStream
```
public abstract void setAsciiStream(int parameterIndex,
                  java.io.InputStream x,
                  long length)
                             throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    x - the Java input stream that contains the ASCII parameter value
    length - the number of bytes in the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
  - setBinaryStream
```
public abstract void setBinaryStream(int parameterIndex,
                   java.io.InputStream x,
                   long length)
                              throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    x - the java input stream which contains the binary parameter value
    length - the number of bytes in the stream
    
    Throws:
    
    java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
  - setCharacterStream
```
public abstract void setCharacterStream(int parameterIndex,
                      java.io.Reader reader,
                      long length)
                                 throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    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:
    
    java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement
  - getDB2ParameterName
```
public abstract java.lang.String getDB2ParameterName(int parm)
                                              throws java.sql.SQLException
```
    Return the name of the parameter for a stored procedure call.
    
    Parameters:
    parm - the parameter number to get the name for
    
    Returns:
    the parameter name.
    
    Throws:
    
    java.sql.SQLException - If a database error occurs.
  - setAsciiStream
```
public abstract void setAsciiStream(int parameterIndex,
                  java.io.InputStream x)
                             throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    x - the Java input stream that contains the ASCII parameter value
    
    Throws:
    
    java.sql.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 abstract void setBinaryStream(int parameterIndex,
                   java.io.InputStream x)
                              throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    x - the java input stream which contains the binary parameter value
    
    Throws:
    
    java.sql.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
  - setBlob
```
public abstract void setBlob(int parameterIndex,
           java.io.InputStream inputStream)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    inputStream - An object that contains the data to set the parameter value to.
    
    Throws:
    
    java.sql.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,
  - setCharacterStream
```
public abstract void setCharacterStream(int parameterIndex,
                      java.io.Reader reader)
                                 throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    reader - the java.io.Reader object that contains the Unicode data
    
    Throws:
    
    java.sql.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
  - setClob
```
public abstract void setClob(int parameterIndex,
           java.io.Reader reader)
                      throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    java.sql.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
  - setNCharacterStream
```
public abstract void setNCharacterStream(int parameterIndex,
                       java.io.Reader value)
                                  throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    value - the parameter value
    
    Throws:
    
    java.sql.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
  - setNClob
```
public abstract void setNClob(int parameterIndex,
            java.io.Reader reader)
                       throws java.sql.SQLException
```
    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 java.sql.PreparedStatement
    
    Parameters:
    parameterIndex - The parameter index (1-based).
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    java.sql.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
  - setObject
```
public abstract void setObject(int parameterIndex,
             java.lang.Object x,
             java.lang.Object targetSqlType,
             int scaleOrLength)
                        throws java.sql.SQLException
```
    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.
    
    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:
    
    java.sql.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 abstract void setObject(int parameterIndex,
             java.lang.Object x,
             java.lang.Object targetSqlType)
                        throws java.sql.SQLException
```
    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.
    
    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:
    
    java.sql.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 abstract long executeLargeUpdate()
                                 throws java.sql.SQLException
```
    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.
    
    Returns:
    either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
    
    Throws:
    
    java.sql.SQLException - - if a database access error occurs; this method is called on a closed PreparedStatement or the SQL statement returns a ResultSet object

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

Fields inherited from interface java.sql.Statement

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

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.PreparedStatement

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

addBatch

addBatch

clearParameters

execute

execute

execute

executeBatch

executeQuery

executeQuery

executeUpdate

executeUpdate

executeUpdate

getMetaData

getParameterMetaData

setArray

setAsciiStream

setBigDecimal

setBinaryStream

setBlob

setBoolean

setByte

setBytes

setCharacterStream

setClob

setDate

setDate

setDB2Default

setDBDefault

setDB2Unassigned

setDBUnassigned

setDouble

setFloat

setInt

setLong

setNull

setNull

setObject

setObject

setObject

setRef

setShort

setString

setTime

setTime

setTimestamp

setTimestamp

setUnicodeStream

setURL

setNString

setNCharacterStream

setClob

setBlob

setNClob

getValidWrappedList

setAsciiStream

setBinaryStream

setCharacterStream

getDB2ParameterName

setAsciiStream

setBinaryStream

setBlob

setCharacterStream

setClob

setNCharacterStream

setNClob

setObject

setObject

executeLargeUpdate