16.20 - Toolbar Button Descriptions - 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
Toolbar Button Name Menu Description
Connect Main toolbar Selects a data source and connect. See Connecting to and Disconnecting from a Data Source 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 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 queries 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 Previews the Answerset and History window before printing. See Using Print Preview 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.
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. For more information, see Using the Right-to-Left Editor for Queries.
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 Changes 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 statements in the Query window. Each statement is submitted separately.
Abort Tools Aborts an executing, or in-flight, query.
Execute Parallel Tools Executes the SQL statements 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.

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
  • You are connected to a database.
Teradata Query Scheduler Tools

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

You can move this command to a menu or toolbar only if:
  • You have the Teradata Query Scheduler (TQS) application (version 5.0 or later) installed on your PC, and
  • You are connected to a database.
List Tables Tools Opens the Table List dialog 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 Opens the Column List dialog 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. For more information, see Editing History Records.
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 Moves the current window to a new tab group, created below the current tab group.
New Vertical Tab Group Window 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.
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 Moves 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 Indents text to the left.
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 Opens 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 rearrange 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.

While in this mode, columns can no longer be selected by clicking on their column headers.
Chart Answerset shortcut Opens the Define Chart dialog 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 Freeze Columns a second time to unfreeze the columns. The default for Freeze Columns is Off.

Decimal Places Answerset shortcut Displays a menu 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 Set the formatting options for the selected cells.
Filter History shortcut Opens the History filter dialog. See Filtering the History Rows for more information.
Clear Filter History shortcut Clears the History filter.