by Brian W. Kelly Book Description Finally, there is a Pocket Query Guide for training IT and non-IT personnel for Query/400. Yes, it is in this big pocket guide form and it is tutorial in nature! You'll be pleased with all the valuable examples, especially result fields, selection and output options. You won't want to put down the first comprehensive guide to Query/400 now that you have your hands on it. This book was overdue 20 years ago, when Query/36 was the offering of the day. As strange as it may seem, there has never been a Query book such as this...ever. Yet, there are tons of expensive Query classes. It is difficult in most companies to get someone to step up to the plate to learn Query. Moreover, OJT is a tough learning experience and an inexact science at best. How do you know if you're ever right? The biggest cost of Query work may be impossible to quantify. The inaccurate answers that are returned from important queries, done by well intentioned, but inexperienced knowledge workers, can be costly. Making important decisions on erroneous information, however, can be even more costly. Then there is the employee turnover issue. Just when they get good at Query, they're gone. There is always another person or a team of people to train. IT is continually training users on the same Query product. Training by any source is expensive. From IBM classes to expensive self-training systems, there is no cheap alternative. It is always expensive, but it doesn't always work. It's difficult to achieve the objectives. Moreover, history suggests that one thing about Query training is always true. In a year or two, you will be doing it again. Not anymore! There is no magic in the Pocket Guide, but everything you need is in there! In addition, it is easy to read. The objective is for the users to train themselves. The iSeries Pocket Query Guide, a little help from co-workers along the way, and a careful evaluation by IT is all you need. The Guide has an example for just about every type of Query you can imagine ó from major result fields to File Joins. You'll see how to do it with examples that you'll use repeatedly. Additionally, for each example, there is a detailed explanation as well as the theory you need to get a head start on becoming a Query/400 guru. Contents: Chapter 1: What Is AS/400 and iSeries Query? Chapter 2: Getting Query Started / Query Management Chapter 3: Work With Queries Chapter 4: Define the Query Panel Chapter 5: Picking the File to Query Chapter 6: Define Result Fields Chapter 7: Select and Sequence Fields Chapter 8: Select Records Chapter 9: Select Sort Fields Chapter 10: Select Collating Sequence Chapter 11: Specify Report Column Formatting Chapter 12: Select Report Summary Functions Chapter 13: Define Report Breaks Chapter 14: Select Output Type and Output Form Chapter 15: Specify Processing Options Chapter 16: Ending Your Query Session Chapter 17: Work With Queries Command (WRKQRY) Chapter 18: Run Query Command (RUNQRY) Chapter 19: Join Case Study Chapter 20: Summary and Conclusions Appendix A: Database Primer for Query/400 Appendix B: IBM Documentation - How to Find it! About the Author Brian Kelly retired as a 30-year IBM Midrange SE in 1999, having cut his eye teeth in 1969 on the System/3 and later with CCP. While with IBM, he was also a Certified Instructor and a Mid-Atlantic Area Designated Specialist. Kelly takes pride in having announced the AS/400 at Marywood University in June, 1988. When IBM began to move its sales and support to Business Partners, he formed Kelly Consulting in 1992 as an IT education and consulting firm. Kelly developed numerous AS/400 professional courses over the years that range from soup to nuts. He has written twenty-one books and numerous magazine articles about current IT topics, including articles for The Four Hundred, Midrange Computing, Showcase, News/400, AS/400 Systems Management, AS/400 Internet Expert, and others. Kelly has also developed and taught a number of college courses and is currently an adjunct member of the graduate faculty at Marywood University in Scranton, Pennsylvania, where he also serves as iSeries technical advisor to the IT faculty. |
Guild Companies · 50 Park Terrace East, Suite 8F, New York, NY 10034 · Telephone: (212) 942-5818 · Email: store@itjungle.com |