When you have finished developing or modifying code, you can then execute the file from within the DB Optimizer environment, on the database of your choosing. This enables you to immediately execute code upon completion of its development. Alternatively, you can save files for execution at a later point in time.
In order to execute a file, you must first associate it with a target database. This is performed by using the drop-down menus located in the Toolbar. When a SQL file is open in the Workbench, the menus are enabled. Select a data source and a corresponding database to associate the file with and then click the green arrow icon to execute the file.
The pair of drop-down menus indicates that the SQL file is associated with the dataotb19 data source and EMBCM database. When the green arrow icon on the right-hand side of the menus is selected, the file is executed on the specified data source and database.
Additionally, if you have turned off auto-committal in the Preferences panel (Window > Preferences), you can commit and execute transactions via the Commit Transaction and Start Transaction icons located next to the Execute icon.
Execute a File
Open the file you want to run and ensure it is associated with the correct database. Click the Execute icon [
]. DB Optimizer executes the code on the database you specified.
Execute a Transaction
Open the transaction file you want to run and ensure it is associated with the correct database. Click the Start Transaction icon [
]. DB Optimizer executes the transaction on the database you specified.
Commit a Transaction
Open the transaction file you want to commit and ensure it is associated with the correct database. Click the Commit Transaction icon [
]. DB Optimizer commits the transaction on the database you specified.