Decompresses data using the zlib 1.2.1 compression algorithm. Use the DECOMPRESS function on data that has been compressed with the COMPRESS function or a compression tool that uses the zlib 1.2.1 algorithm. If the session that decompresses the data uses a different data movement mode than the session that compressed the data, the output of the decompressed data may differ from the original data.
The following table describes the arguments for this command:
Binary datatype. Data that you want to decompress.
Decompressed binary value of the input value.
NULL if the input is a null value.
Your organization has an online order service. You received compressed customer order data over a wide area network. You want to read the data using PowerCenter and load the data to a data warehouse. You can decompress each row of data using DECOMPRESS for the row. The
PowerCenter Integration Service
can then load the decompressed data to the target.