JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

Working with BLOB and CLOB Data

This section describes working with BLOB and CLOB data in JDBC applications. You can use the standard interface

described in the JDBC 3.0 API specification to access BLOB and CLOB data in NonStop SQL/MX tables with support

provided by the JDBC/MX driver.

BLOB and CLOB are not native data types in an SQL/MX database. But, database administrators can create SQL/MX

tables that have BLOB and CLOB columns by using the JDBC/MX driver or special SQL syntax in MXCI as described in

the next section, Managing the SQL/MX Tables for BLOB and CLOB Data.

For management purposes, CLOB and BLOB data is referred to as large object (LOB) data, which can represent either

data type.

Note: Support for BLOB and CLOB data requires SQL/MX tables.

The section is organized in topics by category as follows:

Category Topic

The Physical Files

Architecture for LOB Support

Setting Properties for the LOB Table

Specify the LOB Table Name

Accessing CLOB Data

Storing CLOB Data

Reading CLOB Data

Updating CLOB Data

Deleting CLOB Data

Accessing BLOB Data

Storing BLOB data

Reading Binary Data from a BLOB Column

Updating BLOB Data

Deleting BLOB Data

Miscellaneous

NULL and Empty BLOB or CLOB Value

Transactions Involving Blob and Clob Access

Access Considerations for Clob and Blob Objects

For full working examples showing how to access BLOB and CLOB data, see Appendix A.

For information about creating and managing tables for BLOB and CLOB data, see Managing the SQL/MX Tables for

BLOB and CLOB Data.