Toolbar Button Descriptions - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Toolbar Button Descriptions

The default toolbar buttons are described in the following table.

 

Table 47: Toolbar Button Descriptions 

Toolbar Button

Name

Menu

Description

Connect

Main toolbar

Allows you to select a data source and connect. See “Connecting to and Disconnecting from a Data Source” on page 30 for more information about connecting to data sources.

Disconnect

Main toolbar

Click to disconnect from the current data source.

Data Provider

Main toolbar

Use the drop down box to select the data provider you want to use. The providers include ODBC and .NET for Teradata or Oracle. See “Defining a Data Source” on page 22 for more information.

New Query

File

Opens a new tab in the Query Window. This selection is only available if the option “Allow multiple queries per connection” is selected.

Open Query

File

Opens a previously saved query or reads a file into the Query Window.

Close All Queries tabs

File

Closes all queries. This selection is only available if the option “Allow multiple per connection” is selected.

Save

File

Saves the contents in the active window.

Save As

File

Saves the contents in the active window after prompting for a new file name.

Copy to Notepad

File

Runs the Microsoft Windows Notepad application and transfers the contents of the active window for additional editing.

Print Preview

File

Allows you to preview the Answerset and History window before printing. See “Using Print Preview” on page 57 for more information.

Print

File

Prints the contents of the active window.

Export Results

File

Exports future query results to a Microsoft Access or delimited text file.

Import Data

File

Switches on import mode where parameter data is read from a text file.

Undo

Edit

Undoes the last change made in the Query Window.re

Redo

Edit

Redoes the last change made in the Query Window.

Cut

Edit

Cuts the selected text to the Clipboard.

Copy

Edit

Copies the selected text to the Clipboard.

Paste

Edit

Pastes the contents of the Clipboard into the Query Window.

Clear Query

Edit

Clears the current query

Format Query

Edit

Formats the query by adding line breaks and indentation at appropriate points.

Right-to-left Editor

Edit

Opens an Editor window for writing queries in languages that use a right-to-left format. See “Using the Right-to-Left Editor for Queries” on page 87 for more information.

Find

Edit

Searches the active window for the desired text string.

Find Next

Edit

Searches for the next occurrence of the string that was specified in the previous Find command in the active Window. If you have not yet issued a Find command, it acts as a Find command.

Find Previous

Query toolbar

Searches for the previous occurrence of the string that was specified in the previous Find command in the active Window. If you have not yet issued a Find command, it acts as a Find command.

Replace

Edit

Finds and replaces any or all occurrences of a particular string in the Query Window.

Add Totals

Edit

Displays totals at the bottom of numeric columns. The totals remain after the Answerset has been sorted. Totals do not appear in future Answerset windows unless Add Totals is activated again.

Sort

Edit

Sorts the data in the active window.

Explorer Tree

View

Displays or hides the Database Explorer Tree.

Go To Favorites

View

Moves focus to the Favorites pane, first displaying it if it is not currently visible.

Set Font

View

Allows you to change the font type, style, and size in the active window

Show History

View

Displays or hides the History window.

Previous SQL

View

Copies the SQL from the previous history record to the Query Window.

Next SQL

View

Copies the SQL from the next history record to the Query Window.

Toggle Outline

View

Collapses a logical section of the query, or expands a collapsed section.

Execute

Tools

Executes the SQL statement(s) in the Query Window. Each statement is submitted separately.

Abort

Tools

Aborts an executing, or in-flight, query.

Execute Parallel

Tools

Executes the SQL statement(s) in the Query Window. The entire query is submitted as a single request.

Reconnect

Tools

Reconnect the current Query window to a connection that was dropped for some reason, such as the client PC going into Hibernating mode.

Explain

Tools

Displays an Explain plan for the query.

Visual Explain

Tools

Opens Teradata Visual Explain so you can display a visual EXPLAIN of a single-statement query currently in the Query Window.

Note: You can move this command to a menu or toolbar only if:

  • You have the Teradata Visual Explain application (version 3.0 or later) installed on your PC, and
  • If you are connected to a database.
  • Teradata Query Scheduler

    Tools

    Opens Teradata Query Scheduler so you can schedule your query for later execution.

    Note: You can move this command to a menu or toolbar only if:

  • You have the Teradata Query Scheduler (Teradata TQS) application (version 5.0 or later) installed on your PC, and
  • If you are connected to a database.
  • List Tables

    Tools

    Displays the Table List dialog box where you can enter the name of the database whose tables or views you want to list. The resulting list of tables or view displays in an Answerset window.

    List Columns

    Tools

    Displays the Column List dialog box where you can list the columns in a particular table or view in the selected database. The resulting list of columns displays in an Answerset window.

    Edit History

    Tools

    Opens the Edit History dialog box. See “Editing History Records” on page 148 for more details.

    Cascade

    Window

    Cascades all the child windows within the Teradata SQL Assistant parent window.

    Tile Horizontal

    Window

    Tiles the child windows horizontally to fit within the Teradata SQL Assistant parent window.

    Tile Vertical

    Window

    Tiles the child windows vertically to fit within the Teradata SQL Assistant parent window.

    New Horizontal Tab Group

    Window

    This button moves the current window to a new tab group, created below the current tab group.

    New Vertical Tab group

    Window

    This button moves the current window to a new tab group, created next to the current tab group.

    Help Topics

    Help

    Displays the contents tab for the Help file.

    Audible Notification

    Query shortcut

     Prompts your system to beep when the query has completed and all data has been returned to your PC. The beep also occurs if the query times out, the number of rows exceeds the output limit, or the query is canceled. It is also located on the Query shortcut menu.

    Minimize on Execution

    Query shortcut

    Automatically minimizes the Teradata SQL Assistant window when a query is being processed.

    Prompt for Notes

    Query shortcut

    Prompts you for a note before running any query. This option causes the system to display an input dialog box whenever you submit a query.

    Add to Favorites

    Query shortcut

    Adds the current query or selected text to a Favorites collection. Once the query is added as a favorite, it can be selected for reuse from the Query Builder window. See “Adding a Query to Favorites” on page 84.

    Query Builder

    Query shortcut

    Opens the Query Builder window.

    Insert Date

    Query shortcut

    Inserts the current date in the Query where ever the cursor is placed.

    Bookmark

    Query toolbar

    Adds or removes a bookmark at the current line

    Next bookmark

    Query toolbar

    Moves to the next bookmark

    Previous bookmark

    Query toolbar

    Move to the previous bookmark

    Remove All Bookmarks

    Query toolbar

    Removes all bookmarks

    Show White Space

    Query toolbar

    Displays symbols for tabs and spaces

    Indent

    Query toolbar

    Indents text to the right

    Unindent

    Query toolbar

    Unindents text (to the left) stop recording

    Comment Text

    Query toolbar

    Turns the selected text (or the current line, if no text is selected) into a comment, or turns the current comment into text

    Select Block

    Query toolbar

    Selects a logical block of text when the cursor is positioned at either the start or end delimiter (for comments, parens, Case/End, and so on).

    Delete blank lines

    Query toolbar

    Deletes blank lines from a currently selected part of a query

    Convert tabs to spaces

    Query toolbar

    Converts tabs to spaces in a query

    Uppercase

    Query toolbar

    Converts the selected text to uppercase

    Lowercase

    Query toolbar

    Converts the selected text to lowercase

    Set Repeat Count

    Query toolbar

    Sets the number of times the next keyboard command or macro is executed

    Record Macro

    Query toolbar

    Records a keystroke macro for later playback

    Stop Recording

    Query toolbar

    Stop recording the current keystroke macro.

    Play Macro

    Query toolbar

    Displays the Keyboard Macros dialog to allow selection of the macro to be played.

    Replay Macro

    Query toolbar

    Replays the most recently played macro. If no macro has been played then it displays the Keyboard Macros dialog to allow selection of the macro to be played.

    Column Headers

    Answerset shortcut

    Displays or hides column headers.

    Toggle SQL/Answer

    Answerset shortcut

    Switches between displaying the SQL statement that generated the Answerset or the Answerset data

    Move Columns

    Answerset shortcut

    Places you into “Move Columns” mode, allowing you to re-arrange the columns by clicking on a column header and dragging it to the desired position. To switch off Move Columns mode, click on this item a second time. The default for Move Columns mode is off.

    Note: While in this mode, columns can no longer be selected by clicking on their column headers.

    Chart

    Answerset shortcut

    Displays the Define Chart dialog box to allow you to specify the columns and rows to be charted, along with the chart type and other criteria.

    Freeze Columns

    Answerset shortcut

    Selecting this item “freezes” the left most columns, preventing them from being scrolled off the screen when you scroll a wide Answerset to the right. All columns up to the current column or cell are frozen.

    Click on 'Freeze Columns' a second time to unfreeze the columns. The default for 'Freeze Columns' is 'Off'.

    Decimal Places

    Answerset shortcut

    Displays a menu that allows you to select the number of decimal places to be displayed in the current column

    Group Columns

    Answerset shortcut

    Allows grouping

    Grid Lines

    Answerset shortcut

    Displays or hides gridlines in the current Answerset window

    Merge Cells

    Answer shortcut

    Merges cells that contain the same data in consecutive rows of the Answerset

    Row Headers

    Answer shortcut

    Displays or hides row headers

    Wrap Text

    Answer shortcut

    Wraps the text onto multiple lines if it does not fit entirely within the column on 1 line

    Allow Close

    Answer shortcut

    Allows automatic closing of the selected Answerset window

    Do Not Close

    Answer shortcut

    Prevents automatic closing of the selected Answerset window

    Copy as HTML

    Answer shortcut

    Copies the selected text from the currently active window to the Clipboard as HTML

    Format Cells

    Answer shortcut

    Allows you to set the formatting options for the selected cells

    Filter

    History shortcut

    Opens the History filter dialog box. See “Filtering the History Rows” on page 140 for more information.

    Clear Filter

    History shortcut

    Clears the History filter