Previous Page | Next Page

Data Set Options for Relational Databases

NULLCHARVAL= Data Set Option

Defines the character string that replaces missing SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Default value: a blank character
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Aster nCluster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata

See Also




This option affects insert and update processing and also applies when you use the DBINDEX= and DBKEY= data set options.

This option works with the NULLCHAR= option to determine whether a missing SAS character value is treated as a NULL value.

If NULLCHARVAL= is longer than the maximum column width, one of these things happens:

See Also

DBFORCE= Data Set Option

DBINDEX= Data Set Option

DBKEY= Data Set Option

DBNULL= Data Set Option

NULLCHAR= Data Set Option

Previous Page | Next Page | Top of Page