Controls the representation of null values in the output of the data extraction facility for an ASCII extraction.
TEMP_EXTRACT_NULL_AS_EMPTY controls the representation of null values in the output of the data extraction facility for ASCII extractions. When the TEMP_EXTRACT_NULL_AS_EMPTY option is set to ON, a null value is represented as '' (the empty string) for all data types.
The quotes shown above are not present in the extract output file. When the TEMP_EXTRACT_NULL_AS_EMPTY option is set to OFF, the string 'NULL' is used in all cases to represent a NULL value. OFF is the default value.
For details on the data extraction facility and using the extraction options, see System Administration Guide: Volume 1 > Data Import and Export > Methods of Exporting Data from a Database > Data Extraction Facility.