SQL for IBM i: A Database Modernization Guide
urn:uuid:b48b7ad3-e924-47c5-be0a-a279d9a1039d
$ 71.95 $ 79.95
-
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 Victria-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
-
- Rafael Victria-Pereira has more than 18 years of IBM i experience, as a programmer, analyst, and manager. Over that period, he has been an active voice in the IBM i community, encouraging and helping programmers to transition to ILE and free-format RPG. Rafael has written more than 100 technical articles about topics ranging from interfaces to modern RPG, SQL, and application modernization. He writes in a down-to-earth, easy-to-read, practical style that's highly popular with his audience of IBM technology professionals. Rafael currently works as an Enterprise Architect at the Luis Simµes Group in Portugal. His areas of expertise include programming in the IBM i native languages (RPG, CL, and DB2 for i SQL) and "modern" programming languages, such as C#, Java, and Python, as well as project management and consultancy.
-
Item Number: 5167 Author Name: Rafael Victria-Pereira Publication Date: January 23, 2018 Edition: First Pages: 376 ISBN-10: 1583474498 ISBN-13: 9781583474495 Format: Paperback Product Dimensions: 7 x .75 x 9 inches Shipping Weight: 1.5 pounds Language: English
Related Items
Programming in ILE RPG, Fifth Edition
$ 85.95 $ 95.95
Product Look Inside the Book Author Bio Specifications Since its original publication, Programming in RPG IV has given thousands of students and professionals a strong foundation in the essentials...
Free-Format RPG IV: Third Edition
$ 53.95 $ 59.95
Product Look Inside the Book Author Bio Specifications Traditional fixed-format RPG programmers everywhere are embracing the increased productivity, better readability, and easier program maintenance that comes with the free-format...
21st Century RPG: /Free, ILE, and MVC
$ 62.95 $ 69.95
Product Look Inside the Book Author Bio Specifications IBM i professionals are known for their dedication to the i. But while the platform has evolved, not all i programmers'...
Subfiles in Free-Format RPG
$ 71.95 $ 79.95
Product Look Inside the Book Author Bio Specifications Kevin Vandever's Subfiles in RPG IV (MC Press, 2000) offered easy-to-understand explanations of subfile concepts plus a bounty of practical examples,...
