DB Optimizer can execute SQL code directly on registered data sources. Files are executed via the Execute SQL command in the Run menu, or by clicking the green arrow button on the toolbar.
When an SQL file is open in the Workspace, select it and choose a database and an associated catalog on which you want to execute the file via the lists in the Toolbar. You can click the execute icon to execute code on the specified database and catalog, start a transaction or commit a transaction, or modify SQL session options prior to execution.
To execute a file
Open the SQL file you want to run, ensure it is associated with the correct database, and click Execute. DB Optimizer executes the code on the data source you specified. Results are displayed in the Results view and can be exported into a file via the Data Export wizard, or displayed in multiple file formats (HTML, XML, and TXT formats).
To execute a transaction
Click Commit or Rollback to finish or cancel a transaction. |
To commit a transaction
You can set transactions to auto-commit prior to execution on the SQL Execution node of the Preferences panel. |
See Also:
| | | | | | | |