|
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

Keywords: build db2 sql query, db2 query tool, db2 query, db2 sql query utility, db2 select query, db2 query browser, db2 sql query tools, tool to build db2 query, db2 select query, visual db2 query, db2 query string, db2 sql query builder, udb sql query
|

Click to enlarge
|
Related programs in Business - Databases & Tools |
|
DBDocumentor
Produce cross referenced and hyperlinked documentation of SQL databases.
|
|
Advanced XML Converter
Powerful XML converter quickly turning XML files into HTML, XLS, CSV, SQL, DBF
|
|
CDBF for Windows
View, edit and repair the DBF database files, create reports, export data, etc.
|
|
Export Table to Excel for SQL Server
Export Table for Microsoft SQL Server helps to save table's data to Excel file
|
|
BBAutoHarvest
An EASY to use contact manager/follow-up system for customers, or potential cust
|
|
Data Exchange Wizard
Data Exchange Wizard Loads or export data from/into ANY database
|
|
Database Oasis
Create custom databases in minutes using point-and-click with Database Oasis.
|
|
Visual Importer ETL Standard
Extract, transform and load data into ANY Database from ANY Database or file
|
|
Export Schema to SQL for SQL Server
Creates SQL script for database definitions: tables, views, procedures, keys,etc
|
|
FmPro Script Diff
FmPro Script Diff - The external script editor for FileMaker Pro.
|