Setting History Window Options - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2430
Product Category
Teradata Tools and Utilities
  1. Select Tools > Options.
  2. Click the History tab.
  3. Set the History window options.
    Option Description
    Record queries and metadata in the History Datebase

    Inserts SQL statements into the History table. They are also displayed in the History window whenever a query is submitted.

    The default is selected. When cleared, SQL queries are not logged.

    Record file name in history when using “Save As”

    Select this option to request that a record be added to the history file whenever you Save As query to a file.

    The default is cleared.

    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

    Select this option to prevent duplicate queries from appearing in the History window.

    The default is cleared.

    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

    Select this option to display the elapse time field value in milliseconds.

    The default is cleared.

    Display SQL text on a single line

    Select this option to display SQL text on one line without carriage returns.

    The default is cleared.

    Show Tooltip when mouse over SQL column Select this option to display up to 500 characters of the SQL text when the mouse hovers over the SQL column in the History window.

    The default is selected.

    Require use of the Show History menu to close the history window Select this option to have the application ignore attempts to close the window. This prevents accidentally closing History by clicking on the wrong window.