I am using Congos 10.2 with DB2 10. I have a table with a field that contains JSON format.
I would like to access a field in from the JSON. What are the option for doing this?
Hi!
I do have the same requirement ( json in a table field).
Did you find any solution for your requirement?
Would be fine, if you can share your expiriences.
Thx in advance
Robert
For any vendor with JSON data type or CLOB/VARCHAR hold a JSON value, you would need to use their SQL-JSON functions (i.e. JSON_VAL etc) to extract the fields of the JSON object into a supported data type.