EMS SQL Query for DB2 facilitates rapid and effortless creation of SQL queries for IBM DB2 databases. It offers visual building and direct editing of query texts for user convenience.

With EMS SQL Query for DB2, you can take advantage of several key features to improve your workflow. For one, you can execute queries asynchronously to maintain productivity. Selecting tables and fields is also easy thanks to drag-and-drop operations, and you can even navigate recently used queries to select the ones you need most. Other features, such as syntax highlight, 'quick code', and keyboard templates, further streamline the editing of query text.
If you need to work with larger datasets, EMS SQL Query for DB2 has tools for data grouping and filtering, as well as the ability to create queries with unions and subqueries visually. Should you need to create diagrams based on queries or view query plans, this software has your back. There is even a powerful BLOB viewer/editor that offers several types of viewing BLOB data.
Finally, EMS SQL Query for DB2 offers flexible personalization of the graphical user interface and multi-language GUI support. Overall, if you're looking for helpful software for managing DB2 databases, this utility is worth considering.
Version 3.2:
- Unicode data support is implemented
- The Favourites tab is added to ensure fast access to Favorite Queries
and much more