Re: OPNQRYF question :)

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

At 10:21 PM 8/16/97, Mark wrote:
>Hi TIm,
>
>>I am trying to find out as much about the OPNQRYF function as I can.  I
>>am new to the AS400 and I am sitting in a room with an AS400 programmer
>>with several years experience, and he can't seem to offer me any help on
>>this powerful function, I have been putzing around with it and I have
>>been very impressed with its power and frustrated by my lack of
>>understanding.  I have IBMs Softcopy on my home PC (I can't wait till I
>>get my work PC.. Why is it that the power users are always last?) that
>>gives several excellent examples, I am wondering if suggestions can be
>>made as to where I can get a reference work that you people would
>>recommend on the OPNQRYF function.
>
> I highly recommend Ted Holt's book OPNQRYF Magic, published by MC.  It's
>got hands on, practical stuff and can get you up to speed pretty quickly.
>
> -mark
>

'Chapter 6. Opening a Database File', from the 'Database Programming'
manual is mostly about OPNQRYF, and gives lots more info than the material
presented in the CL manual. Also, look at 'Appendix D. Query Performance:
Design Guidelines and Monitoring' and 'Appendix E. Using the DB2 for OS/400
Predictive Query Governor'. There's some relevant material in the SQL
manuals, esp. on performance, since SQL uses the same processing engine as
OPNQRYF.

Good luck,

Vernon Hamberg
System Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480
root
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *