How to set a field in HANA table to null
How do i set a field in a HANA table to null . I need it to set the parent root node to null for PC Hierarchy.
The statement below does not work as it complains about not able to insert null in the DB
UPDATE TABLE_NAME SET FIELD1 = NULL WHERE FIELD2 = CONDITION