Online Documentation for SQL Manager for DB2

Using Navigation bar and Toolbar


The Navigation bar and Toolbar provide quick access to tools implemented in SQL Script Editor.

 

SQL Script Editor - Using Navigation bar

 

 

The Navigation bar of SQL Script Editor allows you to:

 

Destination group

iconHost select a node

iconDB select a database for the script

 

General group

iconAutoDDL toggle AutoDDL

iconExecute execute the current script

iconCompile execute a script from file

iconNew create a new script

iconLoadFromFile load a script from an *.sql file using the Open SQL Script dialog

iconSaveToFile save the current script

iconSaveToFileAs save the script to an *.sql file using the Save as... dialog

iconSaveToFileAs save the script to an *.sql file to the version control repository folder using the Save as... dialog (available only for databases with Version control enabled)

iconDBExplorer enable/disable parsing of SQL code

iconLogs_EnableLog enable/disable result log

iconOptions configure SQL Script Editor within the Script Options section of the Environment Options dialog

iconRestoreDefaultSize restore the default size and position of the editor window

iconAddToVC include current shared script into version control

iconUpdateFromVC update shared script from version control

iconCommitToVC commit shared script to version control

 

Version Control group

define whether to log executed script to VC if it changes objects or always

specify whether comments to the script should be asked RadioButton before or RadioButton after run

 

Explorer group

iconDBExplorer browse the tree objects used in the script using the Script Explorer panel

 

 

Items of the Navigation bar are also available on the ToolBar of SQL Script Editor. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select RadioButton Toolbar (if you need the toolbar only) or RadioButton Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.