IBM Support

JSON Scalar Functions

News


Abstract

JSON scalar functions have been added to Db2 for i.

Content

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11116423