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 database, select tables and fields for a query, set the selection criteria and many 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.
Changes in this version:
- Unicode data support is implemented- The Favourites tab is added to ensure fast access to Favorite Queriesand much more
System requirements:
600MHz; 128Mb RAM; Possibility to connect to some local or remote DB2 server; IBM DB2 client software installed
( By EMS Database Management Solutions, Inc - EMS SQL Query for DB2 Publisher )