ngsi.com www

IBM Says it’s Time to Replace Query/400. So, What Are Your Options?

Initial Setup Time and Ongoing Administration

NGS-IQ works directly with your DB2 database. It offers a meta data alias feature for those who want to simplify end user understanding and navigation of their database, but aliases are not required. DB2 Web Query requires you to set up and maintain a meta data repository of your DB2 files. Some meta data functions require the separately priced Developer Workbench. All of the optional meta data alias features of NGS-IQ are included in the IQ Server module licensed to all customers.

DB2 files added to DB2 Web Query’s meta data repository aren’t organized by library which can make finding them difficult. You cannot query files stored in your QTEMP library because DB2 Web Query doesn’t allow these files to be defined in its meta data repository. This restriction effectively eliminates the convenience of using QTEMP to store query output that is needed to process a second query.

DB2 Web Query’s meta data repository can be used to identify any Query/400 objects that you wish to run from within DB2 Web Query, but DB2 Web Query requires you to re-enter these query objects in the meta data repository if they have been changed since the last time they were run from DB2 Web Query. This can be frustrating in an environment where DB2 Web Query is being used by some people while others continue using Query/400 to maintain queries.

 

Want to confirm these and other details?

We encourage you to read the DB2 Web Query Redbook.

Learn More About DB2 Web Query.

IBM® DB2® Web Query V1.1 End of Support.

Alternative Solutions Available from NGS.

Legal Notice: NGS believes all of the above information is accurate at the time of publication. However, IBM software products and marketing policies are subject to change at any time, without notice. Speak to your IBM or IBM Business Partner representative for current product, pricing, and support information. We welcome your comments.

Request Literature

Discuss Your Needs

Considering IBM DB2 Web Query?

NGS blog

Follow Us

3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380

Site Map

Copyright & Copy; New Generation Software, Inc. All rights reserved.