SQL for iSeries

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.

Kevin Forsythe has over 19 years of experience on the iSeries and other platforms as programmer, analyst, consultant, and instructor. He blends a wide range of experiences with a passion for teaching and is the author of numerous articles. Kevin has developed AS/Credentials Courses for Interactive SQL and Embedded SQL. He is a frequent and award-winning speaker at COMMON conferences and other iSeries user conferences.