Antwort: [MI400] Retrieve *QRYDFN output file name/library w/o using WRKQRY?

[Peter.Daransky@xxxxxxxx]

Hi Dan, 
i don't know what exactly do you need, but i thin solution for you could 
be  Query Management Programming Guide (SC-41-5703-05). 
It's are some APIs which you can use for *QRYDFN Objects ... I don't know 
if it will help, but you could retrieve from this QRYDFN object a SQL 
definition for that query and so you can analyse it ?! 

Peter

Regards 

Peter Daransky 




Dan <dbcerpg@xxxxxxxxx> 
Gesendet von: mi400-bounces@xxxxxxxxxxxx
11.06.2004 05:01
Bitte antworten an
MI Programming on the AS400 / iSeries <mi400@xxxxxxxxxxxx>


An
mi400@xxxxxxxxxxxx
Kopie

Thema
[MI400] Retrieve *QRYDFN output file name/library w/o using WRKQRY?






Esteemed listers:

Is it possible to write a program that will take a query definition 
(*QRYDFN)
name & its library passed in as parameters and return the query's output 
file,
if it outputs to a data file?

I have a datafile that likely was created by Query, but with hundreds of
queries on the system to choose from, it would be most frustrating to have 
to
open up each query to determine its output file.

TIA, 
Dan


 
 
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.