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

DEC_BASE64

DEC_BASE64

Decodes a base 64 encoded value and returns a string with the binary data representation of the data. If you encode data using ENC_BASE64, and you want to decode data using DEC_BASE64, you must run the decoding session using the same data movement mode. Otherwise, the output of the decoded data may differ from the original data.

Syntax

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

Return Value

Binary decoded value.
NULL if the input is a null value.
Return values differ if you run the session in Unicode mode versus ASCII mode.

Example

You encoded WebSphere MQ message IDs and wrote them to a flat file during a workflow. You want to read data from the flat file source, including the WebSphere MQ message IDs. You can use DEC_BASE64 to decode the IDs and convert them to their original binary value.