Re: Summarised Files

[Buck Calabro/commsoft<mcalabro@xxxxxxxxxxxx>]

>Ok guys could we expand the OPNQRYF explanation 
>- will this create a permanent logical representation 
>which will be updated every time an entry is made at 
>the detail level - and if so could you provide some sample code

OPNQRYF does not create a permanent access path; it builds
a temporary access path for the job that issues the command.
It is typically used for reports, but has great flexibility
because the "select" and "sequence" parts can be specified
at run time (as dynamic as SQL).  It pretty much supplants
FMTDTA these days because of that.

If you are still interested in samples of OPNQRYF, email
me directly so I don't clutter the list.  If you decide
to use OPNQRYF, perhaps we can send the sample code to
David for inclusion on his website...

Buck Calabro
CommSoft, Albany NY
mailto:mcalabro@commsoft.net



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---