Sat, Jun
4 New Articles

  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

You may be familiar with SQL, the IBM DB2 for i data-access language. But you might not know that you can use SQL to modernize your IBM i database, to make it more efficient and easier to access. Rafael Victória-Pereira knows firsthand how to use SQL’s database modernization power—and in SQL for IBM i: A Database Modernization Guide, he shares this knowledge, explaining how you can use SQL’s capabilities to modernize and enhance your IBM i database.

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