• Subject: Re:From Query TO Query Mngmt Query
  • From: Buck Calabro <mcalabro@xxxxxxxxxxxx>
  • Date: Wed, 7 Jan 1998 15:51:07 -0500

>I need to know how to get from a query to a query management query.  I know
>that I need the query defn from the query as source to generate a query
>management query but how do I set this up.  All the commands assume that I
>already have a query management query.  Tried each of these commands and
>nothing quite did what I wanted.  What am I missing.

o You need to create a source file to hold the QM Query source: QQMQRYSRC
o RTVQMQRY to that source file with the member named the same as the 400 query
o Edit your source as needed
o CRTQMQRY using the (modified) source

To process the query, STRQMQRY QMQRY(MYQM)  ALWQRYDFN(*YES).  
This will use your QM Query for the SQL statement, and use the 400 
Query for the formatting.  If you have a need to modify the formatting 
as well, you can:

o Create a source file to hold the QM Form source: QQMFORMSRC
o RTVQMFORM to that file with the member named the same as the 400 query
o Edit your source as needed (Good luck!)
o CRTQMFORM using the modified source

To process this query, STRQMQRY QMQRY(MYQM) QMFORM(*QMQRY)
This will use your QM Query for the SQL and your QM Form for the
formatting.

Hope this helps!
Buck Calabro
Commsoft, Albany, NY

+---
| 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 MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].