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

COMPRESS

COMPRESS

Compresses data using the zlib 1.2.1 compression algorithm. Use the COMPRESS function before you send large amounts of data over a wide area network.

Syntax

COMPRESS(
value
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
value
Required
String datatype. Data that you want to compress.

Return Value

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

Example

Your organization has an online order service. You want to send customer order data over a wide area network. The source contains a row that is 10 MB. You can compress the data in this row using COMPRESS. When you compress the data, you decrease the amount of data the
PowerCenter Integration Service
writes over the network. As a result, you may increase performance.