Re: HTTPPOSTCLOBVERBOSE - invoking a HTTPS web service

It works on V7.1 and V7.3.

Check your PTF levels

<httpHeader responseCode="200">
<responseMessage>OK</responseMessage>
<header name="HTTP_RESPONSE_CODE" value="HTTP/1.1 200 OK"/>
<header name="Server" value="nginx"/>
<header name="Access-Control-Allow-Origin" value="*"/>
<header name="Content-Length" value="434"/>
<header name="Date" value="Mon, 25 Jul 2016 13:34:12 GMT"/>
<header name="Content-Type" value="application/json"/>
<header name="Connection" value="keep-alive"/>
<header name="Access-Control-Allow-Credentials" value="true"/>
</httpHeader>

{
"args": {},
"data": "testing",
"files": {},
"form": {},
"headers": {
"Accept": "text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2",
"Accept-Encoding": "gzip,deflate",
"Content-Length": "7",
"Content-Type": "text/plain;charset=utf-8",
"Host": "httpbin.org",
"User-Agent": "DB2 HTTP Consumer 1.0"
},
"json": null,
"origin": "198.89.160.22",
"url": "https://httpbin.org/post";
}


Eric wrote on 7/25/2016 9:10 AM:

Hi,

I tried running this SQL

SELECT * FROM
TABLE(SYSTOOLS.HTTPPOSTCLOBVERBOSE('https://httpbin.org/post', '',
'testing')) AS X


... which sends a web service to https but there is an issue.

This is from the job log.

Message ID . . . . . . : CPF503E

Date sent . . . . . . : 16/07/25 Time sent . . . . . . :
14:06:59


Message . . . . : User-defined function error on member QSQPTABL.



Cause . . . . . : An error occurred while invoking user-defined function

HTTPPOSTCLOBVERBOSE in library SYSTOOLS. The error occurred while
invoking
the associated external program or service program B2RESTUDF: in library

SYSTOOLS.D, program entry point or external name

com.ibm.db2.rest.DB2UDFWrapper.httpPostClobVerbose, specific name

HTTPPOSTCLOBVERBOSENONXML. The error occurred on member QSQPTABL file

QSQPTABL in library QSYS2. The error code is 1. The error codes and their

meanings follow:

1 -- The external program or service program returned SQLSTATE 38000.
The
text message returned from the program is:

SYSTOOLS.HTTPPOSTCLOBVERBOSE HTTPPOSTCLOBVERBOSENONXML ãjava.lang.ArrayIn

If I change it to use http, it is fine.

Any ideas?

Thanks,
Eric