Re: json_table - get entire array

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.