Forbes currency converter
Rob Berendt <[email protected]>
| Newsgroups | gmane.comp.hardware.ibm.midrange |
|---|---|
| Message-ID | <CAPJ+qQMC+wP2yeeY1iD27KsAXhEOwb5ABXRw+wPSU+HYfufCiw@mail.gmail.com> |
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.