Re: db2 sql json functions json_array to consume an RPG DS

I appreciate that. But I just get a little tired of the "SQL is the answer
... now what was your question" approach that to my mind is far too
prevalent these days.

Not - I hasten to add - that I'm accusing you of this. But these threads
turn up later in people's google searches so I just like to put the options
out there.


Jon P.

On Mar 28, 2024, at 10:56 AM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>

wrote:

I understand that is a route Jon, but I'm using the db2 sql json

functions

in this case

thanks

Jay

On Thu, Mar 28, 2024 at 10:54 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx>

wrote:

Basically you are describing what PRG's DATA-GEN is intended for.


Jon P.

On Mar 28, 2024, at 10:51 AM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>

wrote:

Is there a way to specify an rpg DS in a sql statement using

json_array,

that will
build the array from that DS?

If not what is the best way to consume those array elements into my

json

I'm building amongst
many other pieces of data?

tia

Jay
--
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.

--
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.