The JSON_TABLE() table function has been added to Db2 for i.
The JSON_TABLE table function returns a result table from the evaluation of SQL/JSON path expressions. Each item in the result sequence of the row SQL/JSON path expression represents one or many rows in the result table.
- Many JSON feeds publish JSON in the form of a JSON array.
JSON_TABLE is used to shred JSON documents, and has been extended to also support direct shredding of JSON arrays.
See the SQL Reference for details: JSON_TABLE table function
11 April 2020