URLENCODE and URLDECODE

The URLENCODE and URLDECODE helper REST functions complete URL encoding or decoding of the provided text.

Tip: Start of changeThe sample HTTP user-defined functions are intended to be used within Db2 SQL applications to access remote non-Db2 REST-based services through SQL statements. Do not confuse them with Db2 native REST services, which supports using a REST-based interface to interact with Db2 data from web, mobile, and cloud applications.End of change
Read syntax diagramSkip visual syntax diagramURLENCODEURLDECODE( text, encoding)

The schema is DB2XML.

text
Specifies the text to encode or decode. This argument is defined as a VARCHAR(2048) value.
encoding
Specifies the character set that is to be used. It can be set to NULL where UTF-8 is used as the default.