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 under UNIX and PC, Greenplum, MySQL, ODBC, Oracle, Teradata

Syntax

NULLCHARVAL='character-string'

Syntax Description

'character-string'

specifies a set of characters that are inserted in the place of a null value when null values are not allowed.

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.