TEMP_EXTRACT_QUOTES_ALL option

Function

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

Allowed values

ON or OFF

Scope

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

Default

OFF

Description

This option specifies that all 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.

See the section “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ System Administration Guide for details on the data extraction facility and using the extraction options.

See also TEMP_EXTRACT_COLUMN_DELIMITER option, TEMP_EXTRACT_ROW_DELIMITER option, TEMP_EXTRACT_QUOTE option, and TEMP_EXTRACT_QUOTES option.