You are currently on IBM Systems Media’s archival website. Click here to view our new website.


Incorporating DB2 Web Query Into Applications

Binary shares lessons learned to harness its power


IBM DB2 Web Query for i offers a set of modernized tools for a more robust, extensible and productive reporting solution than the popular Query for System i (also known as Query/400) tool. DB2 Web Query for i preserves investments in the reports developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as is. It also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.

United Kingdom-based Binary Computer Services Ltd, a long-time IBM partner, has been involved with DB2 Web Query since its introduction in the U.K. in 2007. The company has been included in several early beta tests and has successfully used the power of DB2 with EGL.

While demonstrating, installing and training on DB2 Web Query, Binary garnered solid experience with the product. While working on solutions for several customers, Binary encountered two common requirements that needed specific focus:

  1. The integration of DB2 Web Query into existing applications
  2. Building DB2 Web Query solutions that eliminated the need for multiple sign-ons.

The company solved these issues using the DB2 Web Query Software Development Kit (SDK). Now Binary, in concert with IBM, shares the lessons learned.


Claus Weiss is an advisory software consultant with the Rational Software System i - Ecosystem team at the IBM Toronto laboratory. He has degrees in industrial engineering and computer science from the University of Hamburg in Germany. He worked as a systems engineer with IBM Germany and joined the IBM Toronto lab in 1984.

James has been involved with DB2 Web Query since its introduction to the U.K. in September 2007. His responsibilities include pre-sales, education and technical support.

Like what you just read? To receive technical tips and articles directly in your inbox twice per month, sign up for the EXTRA e-newsletter here.



2019 Solutions Edition

A Comprehensive Online Buyer's Guide to Solutions, Services and Education.


A Debate: DDS vs. DDL

Should you switch your DDS defined files to DDL?

IBM Systems Magazine Subscribe Box Read Now Link Subscribe Now Link iPad App Google Play Store
IBMi News Sign Up Today! Past News Letters