TEMP_EXTRACT_SWAP option

Function

Specifies in combination with the TEMP_EXTRACT_BINARY option the type of extraction performed by the data extraction facility.

Allowed values

ON or OFF

Scope

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

Default

OFF

Description

This option is used with the TEMP_EXTRACT_BINARY option to specify the type of extraction performed by the data extraction facility.

Table 2-16: Extraction option settings for extraction type

Extraction type

Temp_Extract_Binary

Temp_Extract_Swap

binary

ON

OFF

binary/swap

ON

ON

ASCII

OFF

OFF

The default extraction type is ASCII.

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 the TEMP_EXTRACT_BINARY option.