If (embedded) SQL would be an option ... look at the JSON_UPDATE Function
which can be used in an UPDATE Statement.
https://www.ibm.com/docs/en/i/7.5?topic=functions-json-update
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Don
Brown via MIDRANGE-L
Sent: Friday, 19 January 2024 04:54
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Don Brown <dbrown@xxxxxxxxxx>
Subject: YAJL - Update a node
Hi All,
We are just starting a new project where we are retrieving details in json.
We are using Scott's YAJLR4
There are times where we need to send back updates.
Unfortunately, the provider of this data wants the entire json string
returned with any changes.
The json we retrieve is about 400 nodes and we only want to change one or
two values.
I can see there are procedures to process the json and retrieve an
individual node's value but there does not appear to be any options to
update a value for a specific node.
If this is the case we will have to define the entire data structure to
handle the entire json document but was hoping there may be another option ?
Any comments or suggestions appreciated.
Thanks
Don
--
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.
midrange.com
