Encodes data by converting binary data to string data using Multipurpose Internet Mail Extensions (MIME) encoding. Encode data when you want to store data in a database or file that does not allow binary data. You can also encode data to pass binary data through transformations in string format. The encoded data is approximately 33% longer than the original data. It displays as a set of random characters.
Syntax
ENC_BASE64(
value
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
value
Required
Binary or String datatype. Data that you want to encode.
Return Value
Encoded value.
NULL if the input is a null value.
Example
You want to read messages from WebSphere MQ and write the data to a flat file target. You want to include the WebSphere MQ message ID as part of the target data. However, the MsgID field is Binary, and the flat file target does not support binary data. Use ENC_BASE64 to encode the MsgID before the