Specifies LOAD statement behavior under certain conditions.
ON, OFF
DBA permissions are not required to set LOAD_ZEROLENGTH_ASNULL. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
OFF
This option specifies LOAD statement behavior under the following 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.
