The URL_ENCODE scalar function completes URL encoding of the provided text using UTF-8 encoding. This is typically used to encode parameter information that is passed as part of the URL.
- An expression that returns a built-in character string that is to be encoded.
The result of the function is a varying length character string that contains character-string after being encoded.
- Create a URL that has the parameter encoded for a request to example.com.
VALUES 'https://www.example.com/search?q=' CONCAT URL_ENCODE('IBM i Q&A')