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 3. Embedded SQL

In the previous two chapters, we discussed using SQL through interactive tools. The techniques covered there form a firm foundation for incorporating SQL into your application designs. There is no point in tackling the complexities of combining SQL and high-level languages such as RPG IV until the basics of SELECT, INSERT, UPDATE, and DELETE are mastered. Experienced iSeries application developers are typically comfortable with languages such as RPG IV, COBOL, and CL. These languages have their own built-in methods for database access. In this section, we discuss replacing the traditional database access techniques in RPG IV with SQL-based operations. COBOL and other languages also support Embedded SQL, and the code is ...

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