EMS logo

Products Navigation

SQL Query for DB2

Our customers

Testimonials

I thank u for your support and surely enjoy the time your software saves me from what I had to do manually first. Best Regards, Jef Schoors
Jef Schoors

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Live Chat with Sales rep.

We will be happy to answer your questions. Please chat or call us: 1-866-775-4968 (toll-free for U.S. & Canada)

News

03/29/2012
SQL Query version 3.4 released
Added the possibility to save SSH connection settings, and other improvements and bug-fixes...
07/27/2011
SQL Query version 3.3 released
Added the automatic display of the JOIN statement for tables with foreign keys in Query Builder, the correct data sorting, and much more…
10/08/2008
SQL Query version 3.2 released
Unicode data support added, visual building of the FROM statement subqueries is now possible, and other improvements and fixes…
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...

EMS SQL Query for DB2

Overview

Download!
Buy online!

EMS SQL Query for DB2 is a useful tool that lets you quickly and simply build SQL queries to IBM DB2 databases. Visual DB2 query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to DB2 databases, select tables and fields for a query to DB2 server, set the selection criteria and much more. Using this query utility you can work with several DB2 queries at once, edit query text in the powerful SQL editor, view the execution results in different modes, create DB2 queries with unions and subqueries visually, build diagrams based on queries, view DB2 query execution plans and perform any other operations you may need in your work with DB2 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
  • 30-day money-back guarantee

Product Screenshots

Enlarge

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

Available Versions

SQL Query 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.

Available Interface Languages

English
English
German
German
French
French
Russian
Russian

Related Products