Specifies in combination with the TEMP_EXTRACT_SWAP option the type of extraction performed by the data extraction facility.
ON or OFF
Can be set for an individual connection. Takes effect immediately.
OFF
This option is used with the TEMP_EXTRACT_SWAP option to specify the type of extraction performed by the data extraction facility.
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_SWAP option.