Online Documentation for SQL Manager for DB2

Using Navigation bar and Toolbar

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

The Navigation bar of View Editor allows you to:

Object group

select a database

select a view for editing

General group

compile the view (if it is being created/modified)

edit the view query using Query Builder

refresh the content of the active tab

print metadata of the view

restore the default size and position of the editor window

Explorer group

browse the view subobjects using the Explorer tree

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 the view:

Triggers group

add a new trigger

edit selected trigger

drop selected trigger(s)

Data Management group

commit transaction

rollback transaction

export data from the view using Export Data Wizard

export data from the view as SQL script using Export as SQL Script Wizard

import data

Description group

save object description to file

load description text from an external *.txt file

copy description to clipboard

DDL group

save DDL to file

open DDL in SQL Editor

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