Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

6 Managing the SQL Tables for BLOB and CLOB Data
This chapter describes for database administrators the creation and management of the tables
required to support LOB data.
NOTE: BLOB and CLOB are not native data types in a Neoview database. But database
administrators can create SQL base tables that have BLOB and CLOB columns by using either the
Type 4 driver or special SQL syntax in HP Neoview Script as described in this chapter.
For management purposes, CLOB and BLOB data is referred to as large object (LOB) data, which
can represent either data type.
This chapter discusses:
• “Before You Begin Managing LOB Data” (page 59)
• “Creating Base Tables that Have LOB Columns” (page 59)
• “Managing LOB Data by Using the Lob Admin Utility” (page 60)
• “Using SQL Triggers to Delete LOB Data” (page 62)
• “Limitations of LOB Data (CLOB and BLOB Data Types)” (page 63)
Before You Begin Managing LOB Data
Before reading this chapter, also read “Architecture for LOB Support” (page 51), which describes
the files for the tables that contain LOB data.
Creating Base Tables that Have LOB Columns
You can write JDBC programs to create base tables that have LOB columns or you can use
Neoview Script.
Data Types for LOB Columns
The data types for the LOB columns are:
CLOB
Character large object data
BLOB
Binary large object data
NOTE: The CLOB and BLOB data type specification is special syntax that is allowed for use in
base tables accessed by the Type 4 driver as described in this manual.
Installing HP Neoview Script
Before using the procedure to create the tables, ensure you have Neoview Script installed on
your workstation.
HP Neoview Script is a product that you can download for free. To obtain Neoview Script:
1. Start a Web browser and navigate to the download site: http://www.software.hp.com
2. Enter the string “Neoview Script” in the search box to search the Software Depot.
3. Download both the Neoview Script software product and the README for HP Neoview
Script, which provides installation instructions.
Using Neoview Script To Create Base Tables that Have LOB Columns
To create a base table that has LOB columns:
Before You Begin Managing LOB Data 59