Online Documentation for SQL Manager for DB2
Visual Query Builder
Visual Query Builder is implemented in SQL Manager for DB2 for building queries visually. The tool allows you to create and edit queries without deep knowledge of SQL. You can also prepare and execute queries, and view the results of their execution.
To open Visual Query Builder, select the Tools | 
New Query Builder / Tools | 
Show Query Builder main menu items or use the corresponding toolbar buttons.
- Using Navigation bar and Toolbar
- Working with diagram area
- Joining two database objects by fields
- Setting the selection criteria
- Setting output fields for selection
- Setting the grouping criteria
- Setting parameters of sorting
- Working with editor area
- Executing queries and viewing results
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
