News
Abstract
The JSON_TABLE() table function has been added to Db2 for i.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > JSON_TABLE() table function
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.
Enhanced with IBM i 7.4 SF99704 Level 7 and IBM i 7.3 SF99703 Level 18:
- 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
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
More support for:
IBM i
Software version:
All Versions
Operating system(s):
IBM i
Document number:
1138492
Modified date:
26 March 2025
UID
ibm11138492
Manage My Notification Subscriptions