TEMP_EXTRACT_QUOTES Option

Specifies that string fields are enclosed in quotes in the output of the data extraction facility for an ASCII extraction.

Allowed Values

ON, OFF

Default

OFF

Scope

Can be set for an individual connection. Takes effect immediately.

Description

This option specifies that string fields are enclosed in quotes in the output of the data extraction facility for an ASCII extraction. The string used as the quote is specified in the TEMP_EXTRACT_QUOTE option, if the default is not suitable.

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.

Related reference
TEMP_EXTRACT_COLUMN_DELIMITER Option
TEMP_EXTRACT_QUOTES_ALL Option
TEMP_EXTRACT_ROW_DELIMITER Option