Specifies the maximum sizes of the corresponding output files used by the data extraction facility. There are eight options: TEMP_EXTRACT_SIZE1 through TEMP_EXTRACT_SIZE8.
AIX & HP-UX: 0 - 64GB Sun Solaris: 0 - 512GB Windows: 0 - 128GB
Can be set for an individual connection. Takes effect immediately.
0
TEMP_EXTRACT_SIZE1 through TEMP_EXTRACT_SIZE8 are used to specify the maximum sizes of the corresponding output files used by the data extraction facility. TEMP_EXTRACT_SIZE1 specifies the maximum size of the output file specified by TEMP_EXTRACT_NAME1, TEMP_EXTRACT_SIZE2 specifies the maximum size of the output file specified by TEMP_EXTRACT_NAME2, and so on.
Note that the default for the data extraction size options is 0. IQ converts this default to the following values:
device type |
size |
|---|---|
disk file |
AIX & HP-UX: 0 - 64GB Sun Solaris: 0 - 512GB Windows: 0 - 128GB |
tape* |
524288KB (0.5GB) |
other |
9007199254740992KB (8192 Petabytes “unlimited”) |
*Tape devices currently are not supported.
If you are extracting to a single disk file or a single named pipe, leave the options TEMP_EXTRACT_NAME2 through TEMP_EXTRACT_NAME8 and TEMP_EXTRACT_SIZE1 through TEMP_EXTRACT_SIZE8 at their default values.
The TEMP_EXTRACT_SIZEn options are not compatible with the TEMP_EXTRACT_APPEND option. If you try to restrict the size of the extract append output file, Sybase IQ reports an error.
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_NAMEn options.
