Online Documentation for SQL Manager for DB2

Using tabs for database navigation


To make your work with SQL Manager for DB2 even more convenient, the capability of working with several tabs is implemented.

 

You can use tabs when you wish to work with a particular node of the DB Explorer tree only: with one specific schema, or with tables of some schema, or with a specific database Favorite objects. Creating such tabs will minimize scrolling within large trees, you only need to switch between them with a single click on the corresponding tab.

 

Standard tabs

 

Standard tabs

 

iconDatabases Databases

This tab provides a quick access to the databases and database objects. The tree-like structure of DB Explorer allows you to manage the databases, database objects and perform other everyday operations quickly and easily. All objects are structured by their types and are available within the corresponding nodes of the tree. The number of objects of each type is displayed in brackets after the node name denoting the object type. To expand/collapse a node, you can double-click it or use the +/- icons.

 

iconWindowsList Windows list

This tab allows you to browse the list of windows that are currently opened within SQL Manager for DB2 IDE. If necessary, you can right-click within the list area to call the popup menu which allows you to bring a window to foreground, close windows one by one or in groups, and to arrange the windows according to your preferences.

 

iconProjects Projects

This tab allows you to view created projects. All objects of the project are structured by their types and are available within the corresponding nodes of the tree. If necessary, you can right-click within the list area to call the popup menu which allows you to launch Compare Databases Wizard or Project Interaction Wizard.

 

Creating tabs

 

In order to create a new tab:

  • right-click the node (e.g. the Tables node) for which you wish to create a tab and select the New Tab from Here... context menu item.

Note: A tab can be created only on the basis of a tree node. For example, if the Show Table Subobjects option is disabled in the View Mode menu, the New Tab from Here... item is not be available for tables, since none of them will be a tree node anymore.

 

DB Explorer - Using tabs - New tab

 

 

The specified tabs can be displayed in either of the two views:

 

  • as icons on the lower panel of DB Explorer:

 

DB Explorer - Using tabs - View as icons

 

  • as tabs with captions:

 

DB Explorer - Using tabs - View as tabs

 

 

Hint: You can reorder items in the tabs view by dragging their captions up and down.

 

 

To add/remove items to/from the tabs view, you can drag the horizontal splitter up/down:

 

DB Explorer - Splitter for tabs

 

or click the Configure buttons icon available in the bottom right corner of the DB Explorer window, and select Show More Buttons / Show Fewer Buttons / Add or Remove Buttons items from the popup menu.

 

DB Explorer - Using tabs - Add or remove buttons

 

 

Note: Navigation through the tabs is also possible with the help of the following shortcuts:

  • Ctrl+Shift+N - move to the next tab;
  • Ctrl+Shift+P - move to the previous tab.

 

Renaming tabs

 

In order to rename a tab:

  • switch to the tab by clicking its caption or icon (there can be only one active tab, and it is highlighted with a different color);
  • right-click within the DB Explorer area and select the Rename Current Tab... context menu item.

 

Removing tabs

 

In order to remove a tab:

  • switch to the tab by clicking its caption or icon (there can be only one active tab, and it is highlighted with a different color);
  • right-click within the DB Explorer area and select the Delete Current Tab context menu item.