Live Chat with Sales rep.

We will be happy to answer any sales or upgrade questions that you have. We can chat online or you can call us.
Toll-free for U.S. & Canada: 1-866-SQL-4-YOU (1-866-775-4968)

| Learn More

SQL Query for DB2 News

04/02/2008
SQL Query version 3.1 released
Faster connection to databases, the ability to save program settings to a REG file is added, and other improvements and bug-fixes...

06/06/2007
SQL Query 2007 released
Support for UNICODE-data in the grid, asynchronous query execution, improved SSH tunneling support and more….

04/13/2006
SQL Query 2005 version 2.2 released
Query result output to a separate tab is now available, other bug fixes and improvements...

12/26/2005
EMS Product Trials CD - all EMS software on one CD
Get all EMS product FREE trials on one low-cost CD with an automatically launched user-friendly shell.

11/16/2005
SQL Query 2005 version 2.1 released.
Quick searching, column summaries in the grid, other improvements and some bugfixes.

09/28/2005
SQL Query 2005 utilities immediately available!
We are pleased to announce the new major version of the powerful utility for building SQL queries for MySQL, PostgreSQL, MS SQL, Interbase/Firebird and DB2 databases!

News Subscribe | More News |

XML content. Requires RSS support to view.

EMS SQL Query for DB2

Print this Page

Overview

Buy now!

Download

EMS SQL Query for DB2 is a utility that lets you quickly and simply build SQL queries to IBM DB2 databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and much more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.

Key Features

User-friendly graphical interface
Asynchronous query execution
Using drag-and-drop operations when selecting tables and fields for a query visually
Working simultaneously with several queries in separate windows
Navigation within recently used queries and selecting the required queries
Syntax highlight, "quick code" and keyboard templates for faster editing query text
Tools for data grouping and filtering
The ability to create queries with unions and subqueries visually
The ability to create diagrams based on queries
Capabilities for viewing query plans
Powerful BLOB viewer/editor with several types of viewing BLOB data
Flexible personalization of graphical user interface
Multi-language GUI support

In-purchase benefits

Acquiring a full set of must-have tools for only 50% of their regular price!
FREE One Year of Maintenance already included!
FREE software updates and upgrades during Maintenance period!
FREE and unlimited Technical Support during Maintenance period!
Reasonable pricing for Maintenance renewal – from 20% per Year!
Volume discounts when buying two or more copies of one product
Cross-selling discounts on related products

Product Screenshots

Powerful and easy-to-use graphical user interface
Exploring databases and their objects

Available Versions

SQL Query 2007 for DB2
EMS SQL Query for DB2 is a utility that lets you quickly and simply build SQL queries to IBM DB2 databases. Visual building as well as direct editing of a query text is available.

Download | Buy options