HTTPPUTBLOBVERBOSE and HTTPPUTCLOBVERBOSE table functions

The HTTPPUTBLOBVERBOSE and HTTPPUTCLOBVERBOSE REST table functions create or update a binary or text-based resource under the specified URL through an HTTP PUT request. They return a one row table that contains the normal HTTP response for the request and the header information returned from the HTTP request.

The schema is SYSTOOLS.

url: Specifies the URL at which to complete the request. This argument is defined as a VARCHAR(2048) CCSID 1208 value.
httpHeader: Specifies an optional header XML document. To use the default HTTP header, specify NULL or the empty string. This parameter is a CLOB(10K) CCSID 1208 or an XML value.; See Foundational HTTP functions for a description of the header content.
requestmsg: Specifies the data to update at the specified URL. For the HTTPPUTBLOBVERBOSE function, this argument is defined as BLOB(2G). For the HTTPPUTCLOBVERBOSE function, this argument is defined as CLOB(2G) CCSID 1208.

The result of the function is a table containing the following two columns.

Table 1. HTTPPUTBLOBVERBOSE and HTTPPUTCLOBVERBOSE result table
Column name	Data type	Description
RESPONSEMSG	BLOB(2G) or CLOB(2G) CCSID 1208 depending on which function is used	The normal HTTP response for the request.
RESPONSEHTTPHEADER	CLOB(1M) CCSID 1208 or XML based on the data type of the httpHeader argument.	Header information returned from the HTTP request.