Re: Forbes currency converter

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 <robertowenberendt@xxxxxxxxx> 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