Re: json_table(httpgetclob, nested array

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 -