Saving History Rows

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

To save history rows

1 Ensure the History window is active.

2 Do one of the following:

On the toolbar, click

From the File menu, click Save History As.

Press Ctrl+S.

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

4 Choose a location and click Save.

File Format Types

You can save the history in the following formats:

Table 34: History File Format Types
File Type	Description
Tab delimited [ANSI}	The data is saved in a tab-delimited file using ANSI. 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. 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. 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 as an Excel 2003 workbook containing one data sheet. The entire Answerset is saved. Column and row headers are saved if they are currently visible.
Microsoft Excel 2007	The data is saved as an Excel 2007 workbook containing one data sheet. 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. 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. 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.