The SQL Editor toolbar enables Connection Profile selection and action buttons that help you manage and execute SQL for supported databases.
The SQL Editor Toolbar contains the following:
- 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 Toggle
- 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 to Selected 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.
- 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
- Lets you load external data into a volatile table.
- Clear Query
- Clears the SQL displayed in the editor.
- Rename Editor
- Renames the editor.
- View 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 Teradata Database 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 Handling Preferences
- Opens the SQL Handling Preferences.