Open Query File Magic!: A Complete Guide to Maximizing the Power of OPNQRYF - Softcover

Holt, Ted

Softcover

ISBN 10: 1883884578 ISBN 13: 9781883884574

Publisher: Mc Press, 1998

Synopsis

OPNQRYF (Open Query File) is the most powerful, most complex, and least documented command in the CL language. You can use it to sort and summarize data, but it can also do much more for you. It allows you to create new fields and assign values to them, perform complex joins of multiple files, create new files with existing and calculated fields, select records (even based on summarized data), and much more! The more you learn about OPNQRYF, the more opportunities you will find to use it in your applications. This book explains the ins and outs of OPNQRYF from the basic operations through the most complex mapping and selection parameters. This new edition of the best-selling book includes invaluable new material. There are new chapters on date data type, ILE, and the Year 2000 issue. The book is reorganized to make it more useful not only as a learning tool, but also as a reference for on-going value.

About this title

About the Author

Ted Holt has been working with midrange systems since 1981 and has been associated with Midrange Computing since 1990. In addition to serving as a senior technical editor for Midrange Computing, he is a consultant specializing in EDI, Y2K, and AS/400 application development. He holds a master of science degree in computer science, and has taught in many universities and technical schools.Because Ted has been a programmer for many years, he understands the challenges facing AS/400 programmers. He understands both S/36 and AS/400 native software, and therefore he understands what problems programmers face and how to fix them. Readers count on him for solid programming advice and tips.

Edition details

• Publisher: Mc Press
• Publication date: 1998
• ISBN 10: 1883884578
• ISBN 13: 9781883884574
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 302