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.

The Navigation bar of SQL Script Editor allows you to:

Destination group

select a node

select a database for the script

General group

toggle AutoDDL

execute the current script

execute a script from file

create a new script

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

save the current script

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

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)

enable/disable parsing of SQL code

enable/disable result log

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

restore the default size and position of the editor window

include current shared script into version control

update shared script from version control

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 before or after run

Explorer group

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 Toolbar (if you need the toolbar only) or Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.