|   The Best and Least Expensive AS/400 and iSeries Query Education Tool!
The System i5 Pocket Query Guide
Author: Brian KellyPrice: $49.00
Availability: Usually ships in 48 hours
ISBN: 0-9721842-4-4
SKU: 5923 | |
 
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!
Product Details: | Audience: | iSeries Programmers | | Level: | Novice to Intermediate | | Subject: | Query | | Length: | 298 pages | | Format: | Paperback, Perfectbound | | Publisher: | Let's Go Publish |
The System i5 Pocket Query Guide
Author: Brian KellyPrice: $49.00
Availability: Usually ships in 48 hours
ISBN: 0-9721842-4-4
SKU: 5923 | |
| |
© 2001-2003 MC Press Online, LP. IBM® and AS/400® are registered trademarks of IBM.
All other product names are trademarked or copyrighted by their respective holders.
MC Press Online Privacy Policy
|
|
|
