Data Access User Manual > Data Access and SQL > SQL Tables > Run-Time Options > Inserting-Nulls Mode
 
Inserting-Nulls Mode
When inserting a row in a database table, the row can contain one or more NULL values.
Here is an example of the SQL statement when the ADDRESS of employee Williams is NULL and the insert-nulls property is enabled:
INSERT INTO EMP(ID, NAME, ADDRESS) VALUES(7, ‘Williams’, NULL)
Alternatively, the following example shows the SQL statement when the insert-nulls property is disabled:
INSERT INTO EMP(ID, NAME) VALUES(7, ‘Williams’)

Version 6.1
Copyright © 2016, Rogue Wave Software, Inc. All Rights Reserved.