The toolbar features buttons in two locations, in the main toolbar and within the SQL Editor itself. The SQL Editor buttons are described below.
From left to right, these buttons are:
Open a SQL Script File: Loads a saved SQL script to be ready for execution. The script is displayed in the SQL Query area.
Save SQL Script to File: Saves the currently loaded SQL script to a file specified by the user.
Execute SQL Script: Executes the selected portion of the query, or the entire query if nothing is selected.
Execute Current SQL script: Execute the statement under the keyboard cursor.
Explain (All or Selection):
Execute the EXPLAIN command on the query
under the keyboard cursor.
Stop the query being executed: Halts execution of the currently executing SQL script. Note: the database connection will not be restarted, and open transactions will remain open.
Toggle whether execution of SQL script should continue after failed statements: If the red “breakpoint” circle is displayed, the script terminates on a statement that fails. If the button is depressed so that the green arrow is displayed, execution continues past the failed code, possibly generating additional result sets. In either case, any error generated from attempting to execute the faulty statement is recorded in the Output tabsheet.
Commit: Commits the current transaction. Note: All query tabs in the same connection share the same transactions. To have independent transactions, a new connection must be opened.
Rollback: Rolls back the current transaction. Note: All query tabs in the same connection share the same transactions. To have independent transactions, a new connection must be opened.
Toggle Auto-Commit Mode: If selected, each statement will be committed independently. Note: All query tabs in the same connection share the same transactions. To have independent transactions, a new connection must be opened.
Beautify SQL: Beautify/reformat the SQL script.
Find panel: Show the Find panel for the editor.
Invisible characters: Toggle display of invisible characters, such as newlines, tabs, spaces.

User Comments
Add your own comment.