We specialize in hard to find items
All Categories
SQL for IBM i: A Database Modernization Guide
Share Tweet
*Price and Stocks may change without prior notice
*Packaging of actual item may differ from photo shown
- Electrical items MAY be 110 volts.
- 7 Day Return Policy
- All products are genuine and original
About SQL For IBM I: A Database Modernization Guide
Product Description 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. From the Inside Flap 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. From the Back Cover 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 About the Author Rafael Victória-Pereira has more than 16 years of IBM i experience as a programmer, analyst, and manager.
