News
Abstract
JSON scalar functions have 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 Scalar Functions
Look in the SQL Reference for complete details:
JSON_VALUE: The JSON_VALUE function returns an SQL scalar value from a JSON text by using an SQL/JSON path expression.
JSON_QUERY: The JSON_QUERY function returns an SQL/JSON value from the specified JSON text by using an SQL/JSON path expression.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
13 January 2020
UID
ibm11116423