How to Quesry JSON

[kennedto]

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?

[rstenitzer]

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

[the6campbells]

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.