NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

SQLMPPreparedStatement

SQLMPPreparedStatement allows an SQL/MP statement to be compiled, stored in an SQLMPPreparedStatement

object, and then executed multiple times.

The SQL/MP drivers support the following SQLMPPreparedStatement methods:

addBatch()●

clearBatch()●

clearParameters()●

execute()●

executeBatch()●

executeQuery()●

executeUpdate()●

getConnection●

getFetchDirection●

getFetchSize●

getResultSetConcurrency●

getResultSetType●

setAsciiStream()*●

setBigDecimal()*●

setBignum()*●

setBlob(int i, Blob x)*●

setBoolean()*●

setByte()*●

setBytes()*●

setClob(int i, Clob x)*●

setDate(), which supports the SQL/MP data type DATE●

setDouble()*●

setFetchDirection●

setFetchSize●

setFloat()*●

setInt()*●

setLong()*●

setNull(), which sets the value of a particular column to null for all SQL/MP data types §●

setObject()*●

setShort()*●

setString()*●

setTime(), which supports the SQL/MP data type TIME●

setTimestamp(), which supports the SQL/MP data type TIMESTAMP●

* These methods support the following SQL/MP data types:

BIGINT●

CHAR●

DOUBLE●

INTEGER (unsigned)●

REAL●

SMALLINT (unsigned)●

VARCHAR●