cancel
Showing results for 
Search instead for 
Did you mean: 

How to set a field in HANA table to null

rajarshi_muhuri
Active Participant
0 Kudos

Hi

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

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

Please post the exact error message.

Right now I'm under the impression that your table has a NOT NULL constraint on FIELD1 which prevents the insertion of NULL values.

- Lars