SQL for eServer i5 and iSeries

SQL for eServer i5 and iSeries

• 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

<div>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.<br></div>