Hi Booth,

How about using httpgetclob to get the data into a variable, then pass that variable to the SQL statement?

At least then you can see the results of the httpgetclob separately to make sure it's getting what you expect it to get.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 11/18/2019 1:46 PM, Booth Martin wrote:
That may be, Jon.  Yes, the examples everyone provided work as provided.  The issue is that I am not trying to read from a file; this is a datastream.

And yes, httgetclob does get the data but that is only half the task.  json_table(httpgetclob...) has to also deliver the data in RPG-usable form.  Otherwise it isn't useful.  It does work just fine for non-array json.

It is the json array that is the issue. Any documentation I find is pretty clear that I need to use both lax and nested. SQLRPGLE appears to me to understand lax but not understand nested.

As to using a loop... there is nothing I see to loop through.

On 11/18/2019 2:35 PM, Jon Paris wrote:
Because while you are using it for the task you have set yourself it is irrelevant to the question at hand.

httpgetclob was completely unrelated to the issues you had -

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.