NULLCHARVAL= Data Set Option

Defines the character string that replaces missing character values during insert, update, DBINDEX=, and DBKEY= processing.
Valid in: DATA and PROC steps
Default: blank
Supports: DB2 UNIX/PC, Greenplum, MySQL, ODBC, Oracle, Teradata
Syntax
Details

Syntax

NULLCHARVAL='character-string'

Details

This option affects insert and update processing and also applies when you use the DBINDEX= and DBKEY= options.
This option works with the NULLCHAR= option, which determines whether a missing character 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.
Copyright © SAS Institute Inc. All rights reserved.