TD_LZ_DECOMPRESS is normally used with ALC to uncompress table columns previously compressed with TD_LZ_COMPRESS.
Calling the function directly requires using the RETURNS clause to specify the desired result data type. Calling the function directly is not recommended for large data types, such as LOBs.