602SQL Development and Management Client

Control Panel

The Control Panel is the basic part of the 602SQL Development Client. The Main toolbar and the commands on the Object sub-menu will only affect the Control Panel.

The panel is composed of two parts, depending on how the window is docked. If the window is floating or docked to the top or bottom, both parts will be next to each other, otherwise they will be above and under.

The first part of the window contains the list of servers that are registered on this computer or they run local network (can be disabled). The application tree is displayed when a server is selected and you are connected to this server. You can descend to the object categories or folders in the individual categories. The list of ODBC Data Sources that are registered on this computer appear on the same level as the 602SQL Server list. Finally, there is a folder for setting client parameters called Local settings.
The second part of the window displays a list of individual objects in the selected category from the first part. After a connection has been established to the server the System folder (users, groups, system tables and server administration) and list of applications are displayed. You can descend to individual objects in this window (tables, procedures, etc.) including user defined folders, and execute certain actions with these objects (create, delete, etc.). You can move to a higher level using the folder with two dots (..). You can move to a lower level by clicking on the desired row (application -> category / folders -> objects). You can change the sorting method by clicking the column header (according to the name or date and time of modification).

You can change the look and layout of the objects in the application tree according to the folders with commands from the View submenu.

Using the Objects

The list of actions that can be done with a selected object (or set of objects), can be displayed with the object pop-up menu or in the Object submenu.

One action (the first in the list) is always defined as primary - this action will be executed when you click the object.

You can execute all basic action with objects of all categories (create, edit, delete, export, import, etc.). You can also move objects using the clipboard (or Drag&Drop) between folders, applications or even servers, if the client is connected to multiple servers at one time. You need to have the privilege to modify the object to execute these actions. Various specific actions exist for different categories (e.g. Rebuild table index, Query optimization, etc.).

More information on the selected object is displayed in the Output window (object text definition, table/query data or object flags).

Interactive object designers are used to create new objects or alter existing ones. A special window that contains a grid filled with records is used to view or edit data in tables/queries.

The Duplicate object(s) pop-up menu command is used to create an exact copy of an object or multiple objects. The new object name is composed of the original name + a number.

List of topics:

602SQL Development Client Layout

602SQL Development and Management Client

Monitor Window