JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

When the Clob objects differ, the Clob object in the updateClob method behaves as if the
setClob method was issued. See Inserting a Clob Object with the setClob Method.
Replacing Clob Objects
You can replace Clob objects in the following ways:
Use the EMPTY_CLOB() function to replace the Clob object with the empty Clob object, then
insert new data as described under Inserting CLOB Columns by Using the Clob Interface.
●
Use the PreparedStatement.setAsciiStream() or setCharacterStream()
method to replace the existing Clob object with new CLOB data.
●
Use the setClob or updateClob method to replace the existing CLOB objects as explained
under Inserting a Clob Object with the setClob Method and Updating Clob Objects with the
updateClob Method.
●
Deleting CLOB Data
To delete CLOB data, the JDBC application uses the SQL DELETE statement to delete the row in the
base table.
When the row containing the CLOB column is deleted by the JDBC application, the corresponding CLOB
data is automatically deleted by the delete trigger associated with the base table. For information about
triggers, see Using SQL/MX Triggers to Delete LOB Data.
See also NULL and Empty BLOB or CLOB Value.
Storing BLOB Data
Inserting a BLOB Column by Using the Blob Interface
Writing Binary Data to a BLOB Column
Inserting a BLOB Column by Using the PreparedStatement Interface
Inserting a Blob Object by Using the setBlob Method
Perform operations on BLOB columns that are similar to those operations used on CLOB columns.
Use the EMPTY_BLOB() function in the insert statement to create an empty BLOB column in the
database.
●
Use setBinaryStream method of the Blob interface to obtain the InputStream to read
BLOB data.
●
Use getBinaryStream method of the Blob interface to obtain the OutputStream to write
BLOB data.
●