IBM Support

JSON - Uniqueness controls for key names

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 UpdatesDb2 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":"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

ibm11116375