ASA Database Administration Guide
Database Options
Alphabetical list of options
Controls whether new columns that are created without specifying either NULL or NOT NULL are allowed to contain NULL values.
ON, OFF
ON
OFF for Open Client and JDBC connections
The ALLOW_NULLS_BY_DEFAULT option is included for Transact-SQL compatibility.
For more information, see Setting options for Transact-SQL compatibility.