Start of change

URL_DECODE

The URL_DECODE scalar function completes URL decoding of the provided text using UTF-8 encoding.

Read syntax diagramSkip visual syntax diagramURL_DECODE(character-string )
character-string
An expression that returns a built-in character string that is currently encoded.

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

Example

  • Decode the string https://www.example.com/search?q=IBM®+i+Q%26A
    VALUES URL_DECODE('https://www.example.com/search?q=IBM+i+Q%26A')
    Returns
    https://www.example.com/search?q=IBM i Q&A
End of change