I'm trying to write a literal null into JSON_TABLE, but I'm getting:
Error: [SQL0206] Column or global variable NULL not found.
Here's the simple example I'm testing:
values JSON_OBJECT('Parameters': null);
This works, but seems silly:
values JSON_OBJECT('Parameters': nullif('', ''));
Is there a better way to force a NULL value?
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.