Saving an Answerset to a File

Saving an Answerset to a File - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product

SQL Assistant

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

dita:id

B035-2430

lifecycle

Product Category

Teradata Tools and Utilities

Saving an Answerset to a File

To save an Answerset to a file

1 Click the Answerset window to make it the active window.

2 Do one of the following:

On the toolbar, click

Select File > Save Answerset As.

Press Ctrl+S.

3 In the Save Answerset dialog box, enter a file name and choose a format type. See “File Format Types”.

4 Choose a location and click Save.

File Format Types

You can save an Answerset in the following formats:

Table 19: Answerset File Format Types
File Type	Description
Tab delimited [ANSI]	The data is saved in a tab-delimited file using the current code page. Any special formatting applied to the Answerset is not saved, but can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Tab Delimited [Unicode]	The data is saved in a tab-delimited file using Unicode. Any special formatting applied to the Answerset is not saved, but can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Tab delimited [UTF-8]	The data is saved in a tab-delimited file using UTF-8. Any special formatting applied to the Answerset is not saved, but can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Delimited Text [ANSI]	The data is saved is a delimited text file using ANSI. To set the use of quotes or to set the delimiter between columns, see “Setting Export/Import Options” on page 131. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Delimited Text [Unicode]	The data is saved is a delimited text file using Unicode. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Delimited Text [UTF-8]	The data is saved is a delimited text file using UTF-8. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Microsoft Excel 2003	The data is saved to an Excel 2003 workbook. If there are multiple tabs in the Answerset window, you are asked whether you want to save all tabs to a single ExcelWorkbook. Any special formatting you have applied to the Answerset is retained. The entire Answerset is saved. Column and row headers are saved if they are currently visible.
Microsoft Excel 2007	The data is saved to an Excel 2007 workbook. If there are multiple tabs in the Answerset window you are asked whether you want to save all tabs to a single ExcelWorkbook Any special formatting you have applied to the Answerset is retained. The entire Answerset is saved. Column and row headers are saved if they are currently visible.
*PDF Document [.pdf]**	The data is saved as a PDF file. Any special formatting you have applied to the Answerset is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved.
*Web Page [htm]**	The data is saved as a table in HTML. Any special formatting you have applied to the Answerset is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved.
XML Document	The data is saved as an XML document. No special formatting is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. See “Saving as XML” on page 115.

Note: Hidden columns are not saved if you save as HTML.

Note: When saving an answerset tab, spreadsheet data is saved using one of the file types from the table above, while Text data is saved using one of the file types described under “To save a query” on page 83.