LOAD_ZEROLENGTH_ASNULL Option

Specifies LOAD statement behavior under certain conditions.

Allowed Values

ON, OFF

DBA permissions are not required. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

OFF

This option specifies LOAD statement behavior under these conditions:

inserting a zero-length data value into a column of data type CHAR, VARCHAR, LONG VARCHAR, BINARY, VARBINARY, or LONG BINARY

and
a NULL column-spec; for example, NULL(ZEROS) or NULL(BLANKS) is also given for that same column

Set LOAD_ZEROLENGTH_ASNULL ON to load a zero-length value as NULL when the above conditions are met.

Set LOAD_ZEROLENGTH_ASNULL OFF to load a zero-length value as zero-length, subject to the setting of option NON_ANSI_NULL_VARCHAR.