News
Abstract
Uniqueness controls for key names has been added to the JSON publishing functions
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > JSON - Uniqueness controls for key names
JSON support is enhanced to include controls to allow or disallow duplicate key names within JSON documents. The WITHOUT UNIQUE KEYS or WITH UNIQUE KEYS clause provides this control.
JSON behavior is changed to default to allowing duplicate key names within JSON documents.
Visit the Memorandum To Users (MTU) for more detail: ibm.biz/IBMi_72_MTU and ibm.biz/IBMi_73_MTU
See the SQL Reference for details:
JSON_OBJECTAGG
JSON_OBJECT
[{"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
ibm11116375