Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. Creating Custom Functions
  8. Custom Function API Reference
  9. POWERCENTERHELP

Transformation Language Reference

Transformation Language Reference

DECOMPRESS

DECOMPRESS

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.

Syntax

DECOMPRESS(
value, precision
)
The following table describes the arguments for this command:
Argument
Required/
Optional
Description
value
Required
Binary datatype. Data that you want to decompress.
precision
Optional
Integer datatype.

Return Value

Decompressed binary value of the input value.
NULL if the input is a null value.

Example

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.