Files can be launched from within the SQL Query Tuner development environment for execution on a registered data source Files are executed via the commands in the Run menu.
When a SQL file is open in the Workspace, select it and choose a database and an associated catalog on which you want to execute file using the drop down menus in the Toolbar. You can click the execute icon to execute the code on the specified database and catalog, start a transaction or commit a transaction, or modify the SQL session options prior to execution.
To execute code
Open the SQL file you want to run, ensure it is associated with the correct database and click the Execute icon. SQL Query Tuner executes the code on the data source you specified. Results are displayed in the same tab or in a new tab.
To execute a transaction
Open the transaction file you want to run and ensure it is associated with the correct database, and then click the Start Transaction icon. SQL Query Tuner executes the transaction on the data source you specified.
To commit a transaction
Open the transaction file you want to commit, ensure it is associated with the correct database, and then click the Commit Transaction icon. SQL Query Tuner commits the transaction on the data source you specified.
You can set transactions to auto-commit prior to execution on the SQL Execution node of the Preferences panel in SQL Query Tuner.