O'Reilly logo

SQL for eServer i5 and iSeries by Kevin Forsythe

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Creating SQL-based Tools

In this chapter, we examine a variety of techniques that allow us to create tools using SQL. These tools help us develop more robust applications. Developers should seek to avoid repetition in coding their applications by creating highly modularized applications. These applications take advantage of the intermediate layers of tools that are typically developed internally to perform specific tasks within the application, although third-party software tools certainly could be acquired and incorporated into the application.

Specifically, this chapter reviews the use of SQL within Query Management (QM) queries and RPGLE programs to create the intermediate tools just described. QM queries allow for the easy development ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required