DB2 DYNAMIC QUERY

DB2 Dynamic Query retrieves, updates, reports and exports DB2 data with no programming or SQL definition. The point-and-click interface guides you through the query definition and report process significantly reducing query development time. Research for customers, MIS requests, project development and trouble shooting is facilitated with the creation of simple or complex queries whose results may be delivered as a display, report sand exported to other applications.

DB2 Dynamic Query Benefits

Enhances Data Mining - Data mining for the business analyst and marketing staff is enhanced with the straightforward query procedure. Complex scenarios are easily requested without programming or SQL definition. Information can be retrieved in any order as determined by the user. Query results can be printed, saved for later use and exported to databases or spreadsheets.

Reduces Query Development Time - The point and click interface allows the user to quickly create simple or complex queries which can be catalogued for reuse. The user interface constructs the query with criteria including ranges, single values, wild cards and lists coupled with selection and exclude logic.

Improves Response Time - Single or multiple step queries produce immediate retrieval of information from your database. Information for customer or management requests may be obtained immediately. Using query results, authorized personnel can make database updates that access edit modules to ensure accuracy of the entry.

DB2 Dynamic Query Features

Some of the query tool's more important features are:

	Easy to use point and click interface
	Enhanced data mining criteria
	Ability to catalog query results and query templates for use at a later time
	Creation of efficient arguments by either selecting or excluding information
	Unlimited number of selection arguments
	Single step capability to update existing rows, add new rows, copy rows and delete rows
	Find feature to locate particular rows in a large query result
	Results can be exported to other formats such as Microsoft Excel, Microsoft Access, Lotus 1-2-3 and others

More Information

For additional information regarding Computrol’s DB2 Dynamic Query tool contact Computrol.

Copyright Š 2006, 2000 Computrol LLC All rights reserved.