SQL For eServer i5 & iSeries

Description

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.

CONTENTS:

Introduction
   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