Incorporate SQL into existing iSeries business and client-side applications
Embed SQL within RPG programs--merging the flexibility of SQL with the power of RPG
Implement referential constraints-primary and unique key indexes-and check constraints
Journal physical files and find out why this task is so important
Extend your database with user-defined functions and procedures
This examination of how SQL functions on the iSeries considers at all possible environments, including the traditional 5250 green screen applications, the SQL scripting tool within iSeries Navigator, and Visual Basic. Database management from creation to deletion is covered in detail. Programmers will learn how to implement referential constraints and primary and unique key indexes, check constraints, and journal physical files. How to extend a database with user-defined functions and procedures and how the new GUI development tools provide simplified methods for running, debugging, and tuning SQL statements are also explained.