Incorporating DB2 Web Query Into Applications

Binary shares lessons learned to harness its power


Reusable Services (SOA)

Software development can be frustrating at times when you have different screens that use the same query or you’re not sure which services to call. One of EGL’s strong points is its built-in support for services. The services can easily be created with EGL and then reused. You could create a dedicated EGL application, purely to host services for DB2 Web Query and then call these services from one or many applications across any platform. This saves replicating the same or similar code each time.

Report Broker Schedules

Binary also worked with customers to provide solutions for scheduling reports to be run overnight. These solutions also allow e-mailing part of a report to various users. The DB2 Report Broker module, announced at the same time as DB2 Web Query SDK, enables the scheduling of reports. These schedules can be invoked via Web service calls.

The Report Broker module allows DB2 Web Query reports to be scheduled and burst so a single report can be broken down into subsections, which can be sent to various user e-mail addresses, based on specified values.

In addition to automated scheduled invocation, developers can provide a user interface for the end user to activate a report directly. When a user within an application realizes that a schedule needs to be overridden or run immediately the user can push a button to activate the report directly.


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.

comments powered by Disqus



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