In this example, the Latin values in the Description column are compressed using the CAMSET_L function with ALC. The DECAMSET_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.CAMSET_L DECOMPRESS USING TD_SYSFNLIB.DECAMSET_L);