Only IBM would come up with such a ridiculous way of making HTTP requests in RPGLE.
SELECT * FROM
TABLE(SYSTOOLS.HTTPPOSTCLOBVERBOSE('
https://httpbin.org/post', '',
'testing')) AS X
SQL syntax for an HTTP request?? For heaven's sake - give me a break!
Eric, stop wasting company time and money on this nonsense and use the tools (that work) that you already have at your disposal. At least then you/we have the ability to diagnose issues if and when they arise.
-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Eric
Sent: 25 July 2016 14:10
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: [WEB400] HTTPPOSTCLOBVERBOSE - invoking a HTTPS web service
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
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
___________________________________________
This email has been scanned by iomartcloud.
http://www.iomartcloud.com/
________________________________
NOTICE: The information in this electronic mail transmission is intended by CoralTree Systems Ltd for the use of the named individuals or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone, so that the sender's address records can be corrected.
--------------------------------------------------------------------------------
CoralTree Systems Limited
25 Barnes Wallis Road
Segensworth East, Fareham
PO15 5TT
Company Registration Number 5021022.
Registered Office:
12-14 Carlton Place
Southampton, UK
SO15 2EA
VAT Registration Number 834 1020 74.
midrange.com
