TEMP_EXTRACT_SWAP option

Function

In combination with the TEMP_EXTRACT_BINARY option, specifies the type of extraction performed by the data extraction facility.

Allowed values

ON, OFF

Default

OFF

Scope

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

Description

Use this option with the TEMP_EXTRACT_BINARY option to specify the type of extraction performed by the data extraction facility.

Table 2-18: 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 also

For details on the data extraction facility and using the extraction options, see “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” in the System Administration Guide: Volume 1.

“TEMP_EXTRACT_BINARY option”