Publisher's Synopsis
A Learn By Example Guide for IBM i-based Application Development Finally, there is a Pocket Developer's Guide for IBM i SQL data- base development. Yes, it is in big pocket guide form and it is tutorial in nature. You'll be pleased with all the valuable explanations and examples. You won't want to put down this comprehensive guide to learning IBM i SQL now that you've got your hands on it. This book is over 20 years overdue. In today's IT landscape, most shops support heterogeneous systems with numerous client and server PCs, and even Unix boxes. Ironically, all of these non-IBM i platforms, from the smallest to the largest have one thing in com- mon in the relational database area. They all use SQL as their data language. That's a big change in the database landscape. SQL is now the industry data / query language standard. IBM backs SQL 100%. A quick look at the SQL function list for the latest release gives a good indication that SQL will have an even more important role in the IBM i future. So, today, it makes little sense for an AS/400 and IBM i professional to not be on board by warming up to SQL - at least for functions that return sets of data. This Guide has an example for just about every type of common SQL function you can imag- ine - from creating tables & views to performing simple and complex selections, column and scalar functions, sub-queries, all the way to unions and joins. Author Brian Kelly designed this book to show you how to use SQL by working with rich examples that you'll use over and over again. Additionally, for each example, there is the explanation you need to get a head start on being an SQL guru. This is the first book to hand to your new developers and veterans alike. More importantly, rather than Oracle being the only database taught at your local Community Colleges and Universities, this new up-to-date IBM i SQL Guide is the right size text for a modern database course. Contains end of chapter extras for teaching / learning.
