Название: SQL for IBM i: A Database Modernization Guide
Автор: Rafael Victoria-Pereira
Издательство: MC Press
ISBN: 1583474498
Год: 2018
Страниц: 375
Язык: английский
Формат: pdf (true), epub
Размер: 23.4 MB

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 author provides comprehensive examples and exercises to help readers understand and practice what they have learned.

The book takes you on a journey: the modernization of a fictional university's database. You'll start with a database that's basically a set of physical files (typical of many RPG applications), then transform it into a proper 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).

As you progress, you'll get plenty of easy-to-understand examples and exercises to help you grasp and master the concepts, so you can use them on the job. The author's down-to-earth style and solid knowledge of SQL on IBM i make for an absorbing, highly educational journey into IBM i database modernization.

After you've read this book, you will know how to:

- Modernize your database, freeing it of its RPG/COBOL shackles
- Migrate your database definition from DDS (the native way) to SQL's DDL (the "modern" way)
- Use advanced SQL concepts, such as user-defined functions, common table expressions, and more
- Make your database easier to access
- Open your database to non-native applications by moving business rules to the database, automating data consistency checks, and more
- Use the system catalog to better understand the database and its components