![TOP_NSORT_CUTOFF_PAGES option [468580]](arrow-left.gif){kind=icon}
![Determining version using sp_iqstatus output [CR 463635]](arrow-right.gif){kind=icon}
The TEMP_EXTRACT_DIRECTORY option controls not only whether a user is allowed to use the data extraction facility but the directory into which temp extract files are placed. It can also override a directory path specified in the TEMP_EXTRACT_NAMEn options.
If the TEMP_EXTRACT_DIRECTORY option is set to the string FORBIDDEN (case insensitive) for a user, then that user is not allowed to perform data extracts. An attempt by this user to use the data extraction facility results in an error: “You do not have permission to perform Extracts”.
If TEMP_EXTRACT_DIRECTORY is set to FORBIDDEN for the PUBLIC group, then no one can run data extraction.
If TEMP_EXTRACT_DIRECTORY is set to a valid directory path, temp extract files are placed in that directory, overriding a path specified in the TEMP_EXTRACT_NAMEn options.
If TEMP_EXTRACT_DIRECTORY is set to an invalid directory path, an error occurs: “Files does not exist File: <invalid path>”
If TEMP_EXTRACT_DIRECTORY is blank, then temp extract files are placed in directories according to their specification in TEMP_EXTRACT_NAMEn. If no path is specified as part of TEMP_EXTRACT_NAMEn, the extract files are by default placed in the server startup directory.
The Sybase IQ manuals will be updated to reflect these changes in the next GA release.
