The SQL Editor provides various options to execute SQL statements within an SQL file. To access the following options, click the appropriate button in the toolbar or right-click inside the SQL Editor text area.
Option | Label | Description |
---|---|---|
Execute as Individual Statements | Executes all statements or selected statements one at a time, displaying the result as a Teradata Group Execution in the SQL Results view. This option allows you to execute SQL DDL statements, which requires its own COMMIT between statements. The group result includes an individual SQL Result for each statement. | |
Execute All | Executes all SQL statements in the SQL File and displays the result as a single entry in the SQL Results view. Multiple result sets display in multiple Result tabs. |