Insert into HSCOMMOND2.JSONCity (JSONTEXT)
Values('{"Success": true}');

Select * from JSONCity
Where JCID = 2;
-- for Update
 ;
Commit;

-- Update: Boolean Value
--------------------------------
-- Converts into "FALSE"
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT, 
                              'SET', 
                              '$.Success', 
                              false)
   Where JCID = 2
   Limit 1
   With NC;       
   
-- Converts into "FALSE"   
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT, 
                              'SET', 
                              '$.Success', 
                              Boolean(false))
   Where JCID = 2
   Limit 1
   With NC;       

-- converts into "FALSE"   
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT, 
                              'SET', 
                              '$.Success', 
                              Cast(0 as Boolean))
   Where JCID = 3
   Limit 1
   With NC;    

-- Error: SQLSTATE 2203F / SQLCODE 16413 - SQL/JSON Scalar required
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT, 
                              'SET', 
                              '$', 
                              JSON_Object('Success': false))
   Where JCID = 2
   Limit 1
   With NC;          
   
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT,
                              'SET',
                              '$.AddObj',  
                              JSON_Object('Success2': true))
   Where JCID = 2
   Limit 1
   With NC;       
   
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT,
                              'SET',
                              '$.AddObj',  
                              JSON_Object('Success2': false))
   Where JCID = 2
   Limit 1
   With NC;  
   
Update HSCOMMOND2.JSONCity
   set JSONTEXT = JSON_Update(JSONTEXT, 
                              'SET',
                              '$.AddObj',
                              Boolean(true)); 
                              
Update HSCOMMOND2.JSONCity
   Set JSONTEXT = JSON_Update(JSONTEXT,
                              'SET',
                              '$.AddObj.Success2',
                              False);