Files can be launched from within the DB Optimizer 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.
- Click the Execute icon. DB Optimizer 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.
- Ensure it is associated with the correct database.
- Click the Start Transaction icon. DB Optimizer 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.
- Click the Commit Transaction icon. DB Optimizer 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 DB Optimizer.