Indicates whether a SAS character missing value is inserted into
the DBMS column as a NULL value.
| Default value: |
SAS
|
| See Also: |
NULLCHARVAL=, DBNULL=
|
-
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.
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.
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
