Extracting null as the empty string

The TEMP_EXTRACT_NULL_AS_EMPTY option 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. For more information about this option, which was not documented previously, see Chapter 2, “Database Options” in the Sybase IQ Reference Manual. For more information about the data extraction facility, see “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ System Administration Guide.