LOAD_ZEROLENGTH_ASNULL option added [CR 383943]

The LOAD_ZEROLENGTH_ASNULL database option added to 12.6 ESD #3 lets you specify 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 (e.g. NULL(ZEROS) or NULL(BLANKS)) is also given for that same column

Setting option LOAD_ZEROLENGTH_ASNULL 'ON' loads a zero-length value as NULL when the preceding conditions are met.

Setting option LOAD_ZEROLENGTH_ASNULL 'OFF' (the default) causes LOAD to load a zero-length value as zero-length subject to the setting of option NON_ANSI_NULL_VARCHAR.