Setting History Window Options - 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
previous
Product Category
Teradata Tools and Utilities

Setting History Window Options

You can control the History window by setting options.

To set options

1 Select Tools > Options.

2 Click the History tab. The following table explains each option.

 

Table 33: History Tab in the Options Dialog Box 

Option

Description

Record queries and metadata in the History Datebase

The default is selected. This option allows SQL statements to be inserted into the History table. They are also displayed in the History window whenever a query is submitted.

When cleared, SQL queries are not logged.

Record file name in history when using “Save As”

The default is cleared. Set this option to request that a record be added to the history file whenever you Save As query to a file.

This record contains the date/time of the save operation together with the fully qualified name of the file that you saved.

Do not save duplicate queries in History

The default is cleared. When the option is selected, duplicate queries do not appear in the History window.

Note: If the duplicate history row to be deleted contains a note, the note is copied to the new history row unless you have provided a new note when the query is executed.

Display milliseconds in elapse time fields

The default is not selected. If the option is selected, the elapse time field appears in milliseconds.

Display SQL text on a single line

The default is cleared. When this option is selected, SQL text displays on one line without carriage returns.

Show Tooltip when mouse over SQL column

The default is selected. This option allows the display of up to 500 characters of the SQL text when the mouse hovers over the SQL column in the History window.

Require use of the Show History menu to close the history window

When this option is selected, the application ignores attempts to close the window by clicking the close button at the top right of the window. This prevents accidentally closing History by clicking on the wrong window.