198 NULLCHARVAL= Data Set Option Chapter 10
NULLCHARVAL= Data Set Option
Defines the character string that replaces SAS character missing values during insert, update,
DBINDEX=, and DBKEY= processing
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value:
a blank character
Syntax
NULLCHARVAL=’character-string’
Details
This option affects insert and update processing and also applies when you use the
DBINDEX=DBKEY= options.
This option works with the NULLCHAR= option, which determines whether or not a
SAS character NULL value is treated as a NULL value.
If NULLCHARVAL= is longer than the maximum column width, one of the following
occurs:
The string is truncated if DBFORCE=YES.
The operation fails if DBFORCE=NO.
See Also
“NULLCHAR= Data Set Option” on page 197
“DBFORCE= Data Set Option” on page 173
“DBNULL= Data Set Option” on page 182
OR_UPD_NOWHERE= Data Set Option
Specifies whether SAS uses an extra WHERE clause when updating rows with no locking
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: Oracle
Default value: LIBNAME setting
Syntax
OR_UPD_NOWHERE =YES | NO
