Modernizing IBM eServer iSeries Application Data Access - A Roadmap Cornerstone

© Copyright IBM Corp. 2005. All rights reserved. 57

Chapter 5. Creating I/O modules to access

SQL objects

When modernizing your database the first step is to convert the DDS-based physical files to

SQL-based tables. In this conversion we want to guarantee that the existing programs keep

working with no changes. This was obtained in our first phase or stage of the methodology.

In this chapter, we move forward in the methodology and we propose the creation of SQL

views and the use of service programs to replace the native I/O access. We cover the steps

required in the second phase or stage proposed in our methodology in “Methodology for the

modernization” on page 25.

In this chapter we cover the following topics:

򐂰 How you can benefit from the power of SQL views in RPG programs

򐂰 Creation of service programs to replace the I/O access

5