JDBC Driver for SQL/MX Programmer's Reference

Home | Contents | Prev | Next | Index | Glossary
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●