Given the following table definition:
CREATE TABLE Pendants (ItemNo INTEGER, Description VARCHAR(100) CHARACTER SET UNICODE);
The following query returns the compressed values of the Description column.
SELECT TD_SYSFNLIB.LZCOMP(Pendants.Description);