BASE64DECODE scalar function

Edit online

The BASE64DECODE function returns a character string that has been Base64 decoded. Base64 encoding is widely used to represent binary data as a string.

Read syntax diagramSkip visual syntax diagram BASE64DECODE ( IN => character-string )
The schema is SYSTOOLS.
character-string
A character string in CCSID 1208 that is currently Base64 encoded. The length cannot exceed 4096 characters.

The result of the function is a varying length character for bit data string that contains character-string after being Base64 decoded.

Example

  • Decode a binary string that was originally X'1122334455'. The result is the original value.
    VALUES SYSTOOLS.BASE64DECODE('ESIzRFU=');