Re: File cross-reference for Query/400

["Carsten Flensburg" <flensburg@xxxxxxxxxx>]

Hi,

I've written an RPG/IV version of the RTVQRYF MI program and added some more
offsets and structures. It still only works at security level 30 or below or
patched to system state. If you're interested you can have a copy of the
source as a starting point for you own modifications.

Best regards,
Carsten Flensburg

----- Original Message -----
From: <owner-midrange-l@midrange.com>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, November 15, 2000 5:04 PM
Subject: Re: File cross-reference for Query/400

Hi, just about three weeks ago I posted a very similar question.
I had been doing some research and thought QQQQRY API could help me, but
could
not find the way to "read the Query Definition Template" (from then on, the
rest
would be easy...), but got some answers that clearly showed that what I
wanted

                         "CAN'T BE DONE... "

I then contacted some one in Rochester, and the answer I got was the same:
Can't
be done.

Two people from this same list answered with two different alternatives:
- one, do a DMPOBJ of the *QRYDFN, then copy its spool file to a physical
file,
then process it with a (RPG) program. Template format should become quite
easy to
decipher using the QDT from QQQQRY API as a guide. Not too good if you got,
as I
did, quite a large number of queries to process...
- second, I was redirected as follows:
        "Go to www.as400network.com.  Search for article by Gary Guthrie in
News/400.
          March 1997, page 117 entitled "Determining Query Specifications".
This

          describes an MI program to retrieve the query file information.
You
can
          download the code.  I believe you must be a member to access the
the
          article and code.

   I am not a MI expert, but looked for it anyway, and it is true you need
to be
a "Proffesional member" to even read the article, and to access its source
code,
and I could not afford the cost of it for just this one case...

So, unhappily enough, I ended up with no acceptable solution...
If you happen to be more lucky than I was, I'd appreciate you input.
Best regards, Antonio

Lou Forlini escribió:

>     I have a client that has close to 1000 Query/400 objects, and
> needs to get a file cross-reference listing for them. As far as I can
> tell, DSPPGMREF won't do it, is there anything out there that can?
> Roll-your-own and commercial solution suggestions welcome.
>
>     Regards,
>
>     - Lou Forlini
>       Software Engineer
>       System Support Products, Inc.
> +---
--
Antonio Fernandez-Vicenti
aiv@ctv.es



+---
| 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
+---