Decodes a base 64 encoded value and returns a string with the binary data representation of the data.
Syntax
DEC_BASE64( value )
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.
Example
You encoded MQSeries message IDs and wrote them to a flat file. You want to read data from the flat file source, including the MQSeries message IDs. You can use DEC_BASE64 to decode the IDs and convert them to their original binary value.