on 08-03-2015 5:15 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.