Incorporating DB2 Web Query Into Applications

Binary shares lessons learned to harness its power


EGL Over Other Languages

EGL, a business-level language for developing business applications that run on multiple platforms, hides the complexities of data access and user interface integration. The advantage of EGL is the support of multiple runtime platforms and the support of multiple user interface technologies built into the language.

EGL is packaged as part of Rational Developer for i for SOA Construction (RDi SOA), thus making EGL readily available to existing IBM i developers. EGL supports the development of rich Web user interface applications using EGL Rich UI. Support for creating and using Web services is also integrated into the language. Using these capabilities makes it very easy for application developers to utilize Web services in DB2 Web Query. For more information on RDi SOA and EGL, see the Rational Developer for i for SOA Construction Web page and visit the EGL Café.

The examples in the DB2 Web Query SDK manual are written in Java and .NET, illustrating how to make the Web-service calls in these environments. However, if you don’t know these languages and have an RPG or COBOL background, it will be easier to use EGL. This is especially true if you’re going to use the DB2 Web Query SDK module.

For example, our experience has been that the code to perform the integration of DB2 Web Query with an existing program is about double the length in Java compared with the EGL implementation. EGL provides a higher abstraction level that results in a reduced length of the program. For example, you don’t have to worry about buffers and print writers to write the output to.


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