Re: Retrieve Query Definition

["Greg Oliver Day" <qsysopr@xxxxxxxxxxx>]

Steve,

There is a tool called RTVQRYF which you can use to retrieve the files used 
in a QRYDFN - both input and outfiles.  I believe it's on the Midrange 
Computer free-code site. I can send you the source, if you can't find it. 
Send me a mail - gregday@ibm.net

I can send you the source.

Regards

Greg Day


>From: "Steve Raisor" <sraisor@kih.net>
>Reply-To: MIDRANGE-L@midrange.com
>To: <MIDRANGE-L@midrange.com>
>Subject: Retrieve Query Definition
>Date: Tue, 30 Nov 1999 13:02:59 -0500
>
>I was wondering if anyone knew of a way to retrieve the definition of 
>query.  I would like to use parts of this definition in a RPG or CL 
>program.  I know I can do RTVQMQRY to retrieve the SQL statement, however, 
>I would like to know if the query is outfiling and if it is, to what 
>library.  I would settle for parsing through the print of a query 
>definition, but see no way to print the definition using a program without 
>running the query using RUNQRY.
>
>Any help would be appreciated!!
>
>Steve Raisor
>Information Systems
>North American Stainless
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
+---
| 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
+---