Expressions on LONGs

Derby permits expressions on LONG VARCHAR; however LONG VARCHAR data types are not allowed in the following clauses, operations, constraints, functions, and predicates.

SQL99 also places some restrictions on expressions on LONG types.
Related concepts
Dynamic SQL
Cursors
Information schema
Transactions
Stored routines and PSM
Calling functions and procedures
Unique constraints and nulls
NOT NULL characteristic
DECIMAL max precision
CLOB and BLOB
ALTER TABLE