|   Open Query File Magic!, Second Edition
A Complete Guide to Maximizing the Power of OPNQRYF
Author: Ted HoltPrice: $69.00
On Sale: $39.95
Availability: Ships in 48 hours
ISBN: 1-883884--57-8
SKU: 590 | |
 
Book Description:
This time-saving book shows you how to exploit the power of IBM's Open Query File (OPNQRYF) to sort, select, summarize, and join data for input to programs. With OPNQRYF, you can allow end users to see data sorted the way they want it, to see only the data fields they are interested in, to calculate new fields, or see data in summary form--all without having to write high-level language programs.
Just as query programs have allowed users to be much more productive, OPNQRYF can make your programs more productive. Instead of writing two or more programs that do more or less the same thing, you can write one flexible program that will handle all foreseen(and many unforeseen) requests of information. The book covers keywords, special parameters, record selection, assigning values to fields, joining two or more files, and much more.
Upon completion of this book, you will be able to:
• Use OPNQRYF to select and sequence records
• Create work variables with OPNQRYF
• Dynamically join files
• Create summary reports and recaps more easily
• Write simpler high-level-language programs
• Convert S/36 sorts to OPNQRYF
• Improve the performance of query processing
• Avoid the errors programmers commonly make when using OPNQRYF
Contents:
Overview
The KEYFLD Parameter
Record Selection
Assigning Values to Fields
Joining Fields
Summary Processing
Reusing an Open Data Path
The CPYFRMQRYF Command
Using OPNQRYF in CL Programs
Using OPNQRYF in Interactive Programs
Other Parameters of the OPNQRYF
Command
Comparing OPNQRYF to FMTDTA
Performance Considerations
Common Run-time Errors
Built-in functions
Optimize Messages
Product Details: | Audience: | Application Programmers | | Level: | Intermediate | | Subject: | Open Query File, Programming--CL | | Length: | 304 pages | | Format: | Paperback, Layflat | | Publisher: | MC Press | | Publish Date: | December 1998 |
Open Query File Magic!, Second Edition
A Complete Guide to Maximizing the Power of OPNQRYF
Author: Ted HoltPrice: $69.00
On Sale: $39.95
Availability: Ships in 48 hours
ISBN: 1-883884--57-8
SKU: 590 | |
| |
© 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
|
|
|
