Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during bulk loading.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | YES |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | OLE DB |
| See: | BL_KEEPNULLS= data set option, BULKLOAD= LIBNAME option |
Table of Contents
specifies that Microsoft SQL Server preserves NULL values that the OLE DB interface inserts.
specifies that Microsoft SQL Server replaces NULL values that the OLE DB interface inserts with a default value, as specified in the DEFAULT constraint.
This option affects values in only Microsoft SQL Server columns that accept NULL and have a DEFAULT constraint.