Re: json_table - get entire array

Daniel,

Yep, I know you can easily fetch an individual value anywhere in the json,
using json_table by specifying the correct path - do it all the time.

But instead of a single value - I want to say, go get me the entire orders
array (and everything inside it)... without having to plop this entire
json into an RPG ds
sql only.

You really shouldn't need an example json to look at to understand this
(we've all seen plenty of jsons) - but trust me, I'd provide it if it
weren't so large and didn't have sensitive info in it.

thanks,

Jay

On Tue, Jul 15, 2025 at 12:00 PM Daniel Gross <daniel@xxxxxxxx> wrote:

Hi Jay,

can you show us the JSON that you want to process and the result table,
that you want to have? It's kinda hard, to Imagine it only from your
description.

You can of course dive directly into a sub-elem-array - you only have to
give the function the correct "path" - and sometimes (most of the time)
it's a bit easier with "lax".

Glad to help, if you have aa example.

Regards,
Daniel

Am 15.07.2025 um 17:55 schrieb Jay Vaughn <jeffersonvaughn@xxxxxxxxx>:

I'm curious about a concept with json_table...

Given the below statement (which is invalid due to the "columns('$')")...
Is there any possible way to have the statement select the entire orders
array, sub array/objects, etc, without having to define that entire
array/subarray/objects DS for that orders array?

select *
from *json_table*(*trim*(jvaughn.tempjson1)
,'$' columns(NESTED '$.orders[*]'
columns('$')
)
) as t
where "dtNr" = '78714';

tia

Jay V
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.