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

§ If you want to set a column in a SQL/MP table to null, you must supply a null indicator when you create the update statement
for the table. For example, if a table is defined as:
create table foo( empnum smallint unsigned not null,
lastname character(20) not null,
deptnum smallint unsigned,
primary key (empnum) ) organization key sequenced");
and you want to insert a new foo row and to set deptnum to null (which is permissible because it is not defined as not
null), you must include a null indicator in the insert statement:
PreparedStatement stmt;
stmt = conn.prepareStatement("insert into foo values(?,?,??);
Notice that the last two question marks are not separated by commas; the first question mark of the pair indicates that a value
can be set for this column (the deptnum column, as these question marks appear in the third position) and the second is the
null indicator, showing that the column can be set to null. If the second question mark were not present, the column could not
be set to null.
The SQL/MP drivers do not support the following SQLMPPreparedStatement methods:
setBinaryStream()●
setUnicodeStream()●
SQLMPResultSet
SQLMPResultSet provides access to a table of data generated by executing an SQLMPStatement object.
The SQL/MP drivers support the following SQLMPResultSet methods:
absolute(int row) getWarnings()
afterLast() insertRow()
beforeFirst() isAfterLast()
cancelRowUpdates() isBeforeFirst()
clearWarnings() isFirst()
close() isLast()
deleteRow() last()
findColumn(String) moveToCurrentRow()
first() moveToInsertRow()
getAsciiStream(int) next()
getAsciiStream(String) previous()
getBigDecimal()
getBigDecimal(int
colIndex)
getBigDecimal(String
colname)
relative(int rows)
getBignum(int, int)
getBignum(String, int)
rowDeleted()
getBlob(int i)
getBlob(String colname)
rowInserted()