EMS SQL Query for DB2

What is EMS SQL Query for DB2?

EMS SQL Query for DB2 is a useful tool that allows you to create fast and simple SQL queries to IBM DB2 databases. Visual creation of DB2 queries, as well as direct editing of query text, are available. The user-friendly graphical interface allows you to connect to DB2 databases, select tables and fields for a query to the DB2 server, define selection criteria, and more. Using this query utility you can work with multiple DB2 queries at the same time, edit query text in the powerful SQL editor, view the execution results in different modes, create DB2 queries with unions and subqueries visually, build schemas based on queries, run the DB2 view query plan, and perform any other operations that you might need in your work with queries to the DB2 database.

Core features

• User-friendly graphical interface
• Asynchronous query execution
• Using drag-and-drop operations when visually selecting tables and fields for a query
• Working simultaneously with multiple queries in separate windows
• Navigation in newly used queries and selection of the necessary queries
• Syntax highlight, "fast code" and keyboard templates for faster editing of query text
• Tools for grouping and filtering data
• The ability to create queries with joints and subqueries visually
• The ability to create queries-based diagrams
• Features for viewing query plans
• Powerful BLOB viewer/editor with various types of BLOB data visualization
• Flexible customization of the graphical user interface
• Multilingual GUI (Graphical User Interface) support.

System requirements

300 MHz processor; Recommended 600 MHz (MHz) processor

Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7.

64 MB of RAM or more; 128 MB or more recommended

20 MB of available HD space for program installation

Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended

Microsoft mouse or compatible pointing device

DB2 Run-Time / Administrative Client 8.0 or higher