Re: Forbes currency converter
cesco via MIDRANGE-L <[email protected]>
| Newsgroups | gmane.comp.hardware.ibm.midrange |
|---|---|
| Message-ID | <[email protected]> |
Why systools, the JVM heavyweight based? use HTTP_GET ... by the way I suspect this isn't a proper api... On Thursday, May 28, 2026 at 04:07:28 PM GMT+2, Rob Berendt <[email protected]> wrote: I'm trying to do the following in Run SQL Scripts values systools.httpgetclob(' https://www.forbes.com/advisor/money-transfer/currency-converter/usd-mxn/?amount=1', ''); I am getting SQL4302 Java stored procedure or user-defined function SYSTOOLS.HTTPGETCLOB, specific name HTTPG00005 aborted with an exception "java.io.IOException:Server returned HTTP response code: 403 for URL: https://www.forbes.com/advisor/money-transfer/currency-converter/usd-mxn/?amount=1". 2026-05-28 10:00:02.714956 30 DIAGNOSTIC Cause . . . . . : The Java stored procedure or user-defined function aborted with a Java exception. If SQJAVA component trace is on, then the component trace for the job contains a Java stack traceback for the aborted method. Recovery . . . : Debug the Java method to eliminate the exception. ROB QSYS QSQROUTS QSQCLNUP SQROUTE_CLEANUP 8501 QSYS QSQROUTS QSQCLNUP SQROUTE_CLEANUP 8501 https://www.ibm.com/docs/en/i/7.6.0?topic=overview-httpgetblob-httpgetclob-scalar-functions -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions. -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.