TEMP_EXTRACT_QUOTES_ALL Option

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

Allowed Values

ON, OFF

Default

OFF

Scope

Requires the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for other user or role.

Description

TEMP_EXTRACT_QUOTES_ALL 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 TEMP_EXTRACT_QUOTE, if the default is not suitable.

Related reference
TEMP_EXTRACT_COLUMN_DELIMITER Option
TEMP_EXTRACT_QUOTES Option
TEMP_EXTRACT_QUOTES_ALL Option
TEMP_EXTRACT_ROW_DELIMITER Option