NULLing Columns with UPDATE

Go Up to Updating Data (Embedded SQL Guide)

To set a column’s value to NULL during update, specify a NULL value for the column in the SET clause. For example, the following UPDATE sets the budget of all departments without managers to NULL:

EXEC SQL
UPDATE DEPARTMENT
SET BUDGET = NULL
WHERE MNGR_NO = NULL;