IBM Power Ideas Portal
This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
IBM does not intend to provide a solution to this request at this time, so it is being closed.
While we agree this could be a useful feature, the database team has many other higher priority requests to deliver so this would not be implemented any time soon.
Using string manipulation functions such as REPLACE, INSERT, and REGEXP_REPLACE can help you update part of the JSON string. Using JSON_TABLE to deconstruct the JSON, performing your updates on this data, and rebuilding it using the JSON publishing functions is another option.
Db2 for i has the same capability as Db2 for z/OS to update a JSON document. This support is the same as updating any string column. You can use a variety of string functions such as REPLACE or INSERT in an update statement. For an example, see https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/json/src/tpc/db2z_updatejsondata.html.
The JSON functions we have implemented are defined in the ANS and ISO standard. These include functions to publish or extract information from JSON but not a more complex update based on the JSON syntax which is proposed by this requirement. You can, however, if the simple update described above is not sufficient, you can extract information (for example, using JSON_TABLE), modify the resulting data, and then use the publish functions to reconstruct the JSON document.
In our workflow, we need to produce and modify JSON documents.
For example :
1 / A job produces JSON documents containing technical and business information: orders containing items
=> Creating the JSON documents
2 / Any order is updatable as long as it is not in preparation
=> Update the JSON documents (items in the orders)
3 / Update the status of items (available / unavailable / ...) during the preparation of the order
...
Today, we chose to work with JSON documents stored in DB2 and other documents on the IFS to facilitate exchanges with other applications.
Another technical need: we want to modify the swagger documents produced by the integrated web services server to add additional information (HTTP codes managed by the program, examples of values, list of supported values ...).
Update of JSON document is available for example with DB2 for Z or mongoDB for the databases, and a lot of languages such node.js, Java, .Net ...
Please provide more information, as requested by CAAC members in the Comment below.
The CAAC has reviewed this RFE. More information is needed. Please give more details about why you would want to modify the JSON object. There are editors out there so you can change the JSON. Also, usually one would request that the JSON be corrected by the sender, and resubmitted.
Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual RFEs on the broader IBM i community, and has therefore reviewed your RFE.
For more information about CAAC, see www.common.org/caac
For more details about CAAC's role with RFEs, see http://www.ibmsystemsmag.com/Blogs/i-Can/May-2017/COMMON-Americas-Advisory-Council-%28CAAC%29-and-RFEs/
Nancy Uthke-Schmucki - CAAC Program Manager