JDBC Type 4 Driver 1.1 Programmer's Reference

Limitations of LOB Data (CLOB and BLOB Data Types)
Limitations of the CLOB and BLOB data types, collectively referred to as LOB data, are:
LOB columns can only be in the target column list of these SQL statements:
INSERT statement❍
Select list of a SELECT statement❍
Column name in the SET clause of an UPDATE statement❍
●
LOB columns cannot be referenced in the SQL/MX functions and expressions.●
LOB data is not deleted from the LOB table when the base row is deleted unless a trigger is established. For
information about triggers, see Using SQL/MX Triggers to Delete LOB Data.
●
LOB data is not accessible if the base table name is changed.●
LOB columns cannot be copied to another table by using the SQL/MX utility commands.●
The name of a base table that has CLOB or BLOB columns must be unique across all catalogs and schemas when
more than one of these base tables share a single LOB table.
●
Note: Adding a trigger can affect up to three schemas. For each schema, you must either own the schema or be the
super ID.
The schema where the trigger is created.●
The schema where the subject table (LOB table) exists.●
The schema where the referenced table (base table) exists.●
Prev Up Next
Chapter 5. Working with BLOB and
CLOB Data
Home
Chapter 7. Type 4 Driver
Compliance
Part Number 529651
Legal Notices