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 Editor.

 

 

 

The Navigation bar of SQL Editor allows you to:

Database group

select a database for the query

 

General group

execute the current query

view estimated query execution plan

run Visual Query Builder to design the query as a diagram

switch the results representation mode: on Edit tab or on separate tab

configure SQL Editor within the Tools | SQL Editor page of the Environment Options dialog

restore the default size and position of the editor window

 

Queries group

add a new query (note that the current query text will not be lost)

rename the current query

remove the query

remove all queries from the editor

edit the query text using Favorites editor and add the query to the Favorite Queries list

 

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with queries:

Edit group

activate the Find Text dialog

load a query from an *.sql file using the Open SQL File dialog

save the query to an *.sql file

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

save all queries to an *.sql file

 

Logs group

activate the Find Text dialog

save the query log to a file

clear logs

 

Data Management group

commit transaction

rollback transaction

export the returned dataset using Export Data Wizard

export the returned dataset as SQL Script using the Export as SQL Script wizard

import data

 

Variables group

browse the list of available SQL variables

 

 

Items of the Navigation bar are also available on the ToolBar of SQL 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.

 

 

---