Online Documentation for SQL Manager for DB2

DB Explorer

General options

 

Show hosts in DB Explorer

Shows/hides hosts in the DB Explorer tree.

 

Show table subobjects

Shows/hides table subobjects (fields, indexes, etc.) in the DB Explorer tree.

 

Show view subobjects

Shows/hides view subobjects in the DB Explorer tree.

 

Sort by aliases

Use this option to apply sorting registered nodes and databases by their aliases in the DB Explorer tree.

 

Rename objects by editing in place

Allows you to edit object names in DB Explorer by selecting any object and clicking its alias one more time.

 

Search by categories

This option determines the search scope when the Find Item feature is used: if this option is selected, the search is performed within the currently selected category (node in the tree) only.

 

Use case sensitive search

If this option is selected, the search string case is considered when using the Search Panel.

 

Refresh objects on showing in SQL Assistant

This option enables/disables refreshing objects each time they are displayed in SQL Assistant.

 

Auto expand navigation panel

If this option is selected, the navigation panel will be expanded every time you start SQL Manager for DB2

 

Show hint

The option enables/disables hints for objects in the DB Explorer tree.

 

 

 

Recent objects count

Defines the number of objects displayed within the Recent menu of the DB Explorer.

 

Table / View / Procedure / Function / Other objects' details in SQL Assistant

These options switch the SQL Assistant mode for displaying details for DB2 objects selected in the DB Explorer tree:

for tables: fields, primary/unique keys, Foreign keys, checks, indexes, triggers, table status, definition or description;

for views: fields, triggers, definition or description;

for procedures/functions: parameters, definition or description;

for other objects: definition or description.

 

 

---