Online Documentation for SQL Manager for DB2

Using Navigation bar and Toolbar

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

The Navigation bar of MQ Table Editor allows you to:

Object group

select a database

select a materialized query table for editing

General group

compile the materialized query table (if it is being created/modified)

add a new field to the materialized query table (if it is being created)

delete the selected field from the materialized query table (if it is being created)

run Query Builder for visual SQL building (if the materialized query table is being created)

refresh the content of the active tab

make a snapshot of the materialized query table (if it is being edited)

print metadata of the materialized query table

restore the default size and position of the editor window

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 materialized query table:

Data Management group

commit transaction

rollback transaction

export data using Export Data Wizard

export data 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 MQ Table 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.