DB2 Code Factory online Help

Return to chapter overview

Visual Query Builder

Visual Query Builder is provided for building queries visually. It allows you to create and edit queries without knowledge of SQL, prepare and execute queries, and view the results of the execution.

To open Visual Query Builder, select the Tools | Query Builder main menu item.

•	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 query and viewing results

See also: SQL Editor

Return to chapter overview

News

Jul 10, 2008

Code Factories advanced to version 8.7

Unicode support, HTTP tunneling, Code Formatter, SQL Generator and other useful things. There are versions for all the supported DBMS (MySQL, Oracle, SQL Server, etc).

Apr 30, 2008

Start of DB2 tools family

We are pleased to introduce the new tools family and its products: DB2 Maestro, DB2 Data Wizard, and DB2 Code Factory.

Sep 1, 2005

New Version Format

We consider it necessary to inform you that the format of product release versions has been formalized.

More news

Feature of the day

Visual Query Builder

DB2 Code Factory allows to design queries as visual diagrams.

Data Export

With DB2 Code Factory you can also export result sets to as many as 14 file formats including Excel, RTF and HTML.