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
To execute 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 in DB Optimizer. |
| | | | | | | |