Online Documentation for SQL Manager for DB2

How to...


The succeeding pages of this chapter are intended to provide you with brief instructions on how to perform this or that operation correctly using SQL Manager for DB2.

 

Work with Databases

Connect to a database

Create a database

Edit database connection parameters

Make work with a database faster

Design a visual database structure

View an ER diagram

Backup a database

Restore a database from a backup

Create a database copy

Document a database

Save metadata reports to file

Log database changes

Get an SQL dump

Synchronize two databases

 

Work with Database objects

Group objects

Find objects

View dependecies

Get an object DDL

 

Work with Data

View tables with many records

Set data filter

Sort and group data

Export/import data

Export data as SQL script

Export filtered data

Edit data of master-detail tables

Add image to table

Set data display format

 

Work with Queries and Scripts

Create SQL statements rapidly

Control a query productivity

Work with several queries an once

Save most frequently used queries

Execute queries with parameters

Export query results into file

Execute scripts

Execute a large SQL script

Make SQL script work faster

Customize work with Query/Script text

View executed queries and scripts

 

Work with version control

Enable version control

Rollback to previous revision state

View database changes

View procedure changes

 

Work with database objects offline

Transfer program settings

Create a simple report in Report Designer

Update SQL Manager

Report bugs and suggestions