Description
Book SynopsisThis 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.
Table of ContentsIntroduction Ch 1: Interactive SQL Ch 2: SQL in iSeries Navigator Ch 3: Embedded SQL Ch 4: Advanced SQL Examples Ch 5: Optimizing SQL Ch 6: Creating Databases Objects Ch 7: Creating Functions Ch 8: Creating Stored Procedures Ch 9: Creating SQL-based Tools Ch 10: Using SQL from within Microsoft Office Appendix A: SQL Basics for Beginners
