Query Development | SQL Editor Toolbar | Teradata Studio/Studio Express - SQL Editor Toolbar - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
ztp1648839236373.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
Product Category
Teradata Tools and Utilities

The SQL Editor toolbar enables Connection Profile selection and action buttons that help you manage and execute SQL for supported databases.

Toolbar Item Description
Connection Profile Select a Connection Profile from the list. If the selected profile is not connected, confirm you want to connect by clicking Yes, enter the connection password, and click OK.
Connection Status Shows the status of the connection to the selected Connection Profile. Green indicates that the connection is active.
Autocommit When selected, submits each SQL statement in autocommit mode. Each SQL statement is then executed in its own transaction that ends with a COMMIT statement. You cannot roll back an SQL statement that is executed in autocommit mode. When Autocommit is set to ON, the Autocommit check box in the toolbar is selected. To turn Autocommit OFF, clear the check box.
Connect profile Connects to the connection profile, if it is disconnected.
Commit If Autocommit is off, performs a commit.
Rollback If Autocommit is off, performs a rollback.
Max Rows Changes the maximum number of rows returned by SQL executed in this editor.
SQL Execution Options Displays a list of Execute options. You can select to Execute an Individual Statement that you have selected, or to Execute All query statements in the editing pane.
Cancel Running Statements Aborts a running SQL request.
Save Options Saves the SQL file to a project or exports the file to a file system.
Export Results to File When toggled on, exports the SQL results to a file instead of displaying in the Result Set viewer.
Import Data to Volatile Table Loads external data into a volatile table.
Clear Query Clears the SQL displayed in the editor.
Rename the SQL Editor Renames the editor.
View asociated result sets View result sets created by this editor.
String Substitution When toggled on, performs a direct string substitution for parameters in the SQL Editor. When the SQL is executed a dialog box appears for the user to enter the substitution for a named parameter in queries. Pertains to Vantage and Aster 6 and later systems, not Hadoop.
New SQL Editor Opens a new SQL Editor. This action does not close the current editor, enabling you to work with multiple editors in tandem.
SQL Editor Preferences Opens the SQL Handling Preferences dialog.