LOAD_ZEROLENGTH_ASNULL option

Function

Specifies LOAD statement behavior under certain conditions.

Allowed values

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.

Default

OFF

Description

This option specifies LOAD statement behavior under the following conditions:

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.

See also

“NON_ANSI_NULL_VARCHAR option”

“LOAD TABLE statement”