JDBC Type 4 Driver 1.1 Programmer's Reference

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.
●
Use setBinaryStream of the PreparedStatement interface to write the data to
the BLOB column.
●
Inserting a BLOB Column by Using the Blob Interface
When you insert a row containing a BLOB data type, you can insert the row using an empty
BLOB value before the column can be updated with real BLOB data. To insert an empty BLOB
value in an SQL/MX database, specify EMPTY_BLOB() function for the BLOB column in the
insert statement.
The Type 4 driver scans the SQL string for the EMPTY_BLOB() function and substitutes the
next-available data locator.