NULLCHAR=

NULLCHAR=

Indicates whether a SAS character missing value is inserted into the DBMS column as a NULL value.

Default value: SAS

See Also: NULLCHARVAL=, DBNULL=

Syntax
Details

Syntax

NULLCHAR=SAS | YES | NO

SAS: indicates that a NULL value is inserted if the DBMS allows NULL. Otherwise, the value that is specified by the NULLCHARVAL= data set option is inserted. If NULLCHARVAL= is not specified, a blank is inserted.
YES: indicates that a NULL value is inserted if the DBMS allows NULL. Otherwise, an error is returned.
NO: indicates that the value specified by the NULLCHARVAL= data set option is inserted. If NULLCHARVAL= is not specified, a blank is inserted.

Details

The NULLCHAR= option determines whether or not a NULL is inserted into the DBMS column when there is a character missing value in the SAS data set.

The NULLCHAR= option works in conjunction with the NULLCHARVAL= data set option, which determines what is inserted if NULL values are not allowed. If NULLCHAR=NO, the value specified by NULLCHARVAL= is inserted, regardless of whether the DBMS allows NULLs for the column. NULLCHAR= affects insert and update processing. Note that all SAS numeric missing values (represented in SAS as '.') are inserted into the DBMS as NULLs.

Chapter Contents
Previous
Next
Top of Page