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
As an Amazon Associate we earn from qualifying purchases.