To define a compressed table, use the compression specification (COMPRESSED) in the column definition in the CREATE TABLE definition SQL statement. If necessary, also specify a split compression size. Note that the following conditions apply to the compression specification:

• A compression specification can only be specified for columns (it cannot be specified for tables).
• A compression specification can only be specified for columns of the following data types:
  
  • BINARY type whose definition length is 256 bytes or greater
  • Abstract data type (XML type)^#

#

To compress data in a column with the abstract data type (XML type), HiRDB XML Extension version 09-03 or later is required.