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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.