HTTPPOSTBLOBVERBOSE and HTTPPOSTCLOBVERBOSE table functions

The HTTPPOSTBLOBVERBOSE and HTTPPOSTCLOBVERBOSE REST table functions update a binary or text-based resource under the specified URL through an HTTP POST 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 HTTPPOSTBLOBVERBOSE function, this argument is defined as BLOB(2G). For the HTTPPOSTCLOBVERBOSE 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. HTTPPOSTBLOBVERBOSE and HTTPPOSTCLOBVERBOSE 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.