This book aims to give IBM i technical users basic to intermediate SQL knowledge and tools they can use to get more out of the IBM i database. The book can be useful to veteran IBM i programmers, who have RPG and COBOL roots, system administrators looking to get more information out of their IBM i system, or even Java and .NET developers who need to "talk" to IBM i database. The book takes the reader on an easy-paced journey, following the modernization of a fictitious university's database. It starts with a basic database, then evolves that database into a SQL database with advanced features that can be used both internally (by an RPG application, for instance) or externally (by a .NET or Java Web application). The author provides comprehensive examples and exercises to help readers understand and practice what they have learned.
SQL for IBM I : A Database Modernization Guide