In this example, the Latin values in the Description column are compressed using the LZCOMP_L function with ALC. The LZDECOMP_L function uncompresses the previously compressed values.
CREATE MULTISET TABLE Pendants (ItemNo INTEGER, Gem CHAR(10) UPPERCASE CHARACTER SET LATIN, Description VARCHAR(1000) CHARACTER SET LATIN COMPRESS USING TD_SYSFNLIB.LZCOMP_L DECOMPRESS USING TD_SYSFNLIB.LZDECOMP_L);