RE: how to query an *qrydfn

["Peter Vidal" <Peter_Vidal@xxxxxxxx>]

>Peter,
>That doesn't work for me.
>I picked a regular ole query and hit enter and got:
>
>RTVQMQRY QMQRY(LEEQUERY/DPBINVLOC) SRCFILE(ISSRCEP/QQRYSRC) 
>Object DPBINVLOC in library LEEQUERY not found. 
>EXPORT QUERY command ended due to error. 
>RTVQMQRY command failed. 
>The query is DEFINITELY in that library but this command defines whatever 
it
>is looking for as a type *QMQRY (?)
>Chuck

You need to specify ALWQRYDFN(*YES).  Besides, I understood that Jerry was 
looking for this.  However, never mind.  This command will not tell if a 
file is been used and obviously not even if it is been replaced or having 
new records coming in.  However, if you know how to "automagically" print 
a query definition (which I have seen in the midrange list been 
addressed), then what I will also recommend is to:

Prepare a CL to create a work file with all *QRYDFN objects
Read each object name and print the *QRYDFN
Copy the spooled file into a database file
Goto step 2 until *EOF
Search on the database file for the output definition information of all 
*QRYDFN objects in that library or libraries.

Peter Vidal
PALL Aeropower Corporation
SR Programmer Analyst
5775 Rio Vista Drive
Clearwater, FL 33760-3137
(727)539-8448
www.pall.com

"My religion consists of a humble admiration of the illimitable superior 
spirit who reveals himself in the slight details we are able to perceive 
with our frail and feeble mind."
Albert Einstein