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

Explains a little-documented command in the CL language that can be used to sort and summarize data, create new fields and assign values to them, perform complex joins of multiple files, create new files with existing and calculated files, select records, and other tasks. Begins with the basic operations and advances to complex mapping and selection parameters. First published in 1992, and here augmented with new chapters on date data type, ILE, and Year 2000 concerns. No bibliography. Annotation c. by Book News, Inc., Portland, Or.

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.