× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 25-Jul-2016 08:10 -0500, Eric wrote:

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

[changed my mind; sending this from my drafts]

The above information for ErrCde1 was truncated; presumably:
SYSTOOLS.HTTPPOSTCLOBVERBOSE HTTPPOSTCLOBVERBOSENONXML ã java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 64 .

Note: the replacement data for the qualified service program name is corrupted; clearly a defect: "program B2RESTUDF: in library SYSTOOLS.D" presumably should have been diagnosed as "program DB2RESTUDF in library SYSTOOLS".


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

Any ideas?


Consider posting on midrange-l instead.? [further comment here was placed instead, in my other recent reply to this thread]

FWiW: if making multiple postings across fora for a specific issue, probably worthwhile to include a link to those other topic threads [or at least maintain the same visible nym as text within the postings] when posting to an additional forum, so a reader can know, rather than merely presume, that the discussions are duplicates; for reference to an apparently duplicate topic on another forum:
Forum Directory ->‎ Information Management ->‎ Forum: DB2 for i ->‎ Topic: HTTPPOSTCLOBVERBOSE SSL issue
Authored by etan84 19-July-2016
[https://www.ibm.com/developerworks/community/forums/html/topic?id=fac6d4cd-8e0e-4e73-b22b-f8ae59ba1607&ps=25]


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.