Specify Default Output Format and Location for Query Results
For query results, you can specify the display location, the file-saving location, and the output format on the Option dialog’s
Query Results page—see
Query Results Options (Options Dialog).
To specify options for query results
1. Click Home, Options to open the Options dialog.
2. Click the triangle at the left of the Query Results heading and then click the General heading.
3. Select the default destination for query results from the drop-down list.
4. Define a default location to save query results. Click the browse button (...) to navigate to a location.
5. (Optional) If you selected “Results to grid” in Step 2:
a. Click the Results to Grid heading.
b. Specify whether you want to include the query statement in the result set.
c. Specify whether you want to include column headers in the query results set.
d. Specify the number of fractional digits to show for float values.
6. (Optional) If you selected “Results to text” in Step 2:
a. Click the Results to Text heading.
b. Select an output format.
If you selected Custom delimiter, specify the custom delimiter character you want to use. (This field is unavailable for any other output formats.)
c. Specify whether you want to include the query statement in the result set.
d. Specify whether you want to include column headers in the query results set.
e. Specify the number of fractional digits to show for float values.
7. Click OK.
Your selection for results output is reflected on the
Query Tab.