|
> From: mnaughton@juddwire.com (Mike Naughton) > > Hi Everyone, > > My operator came to me with a question that has me stumped. She ran a > query for someone (simple RUNQRY off her menu), and along with the actual > query output it also printed the query definition. This came as a > surprise, so she asked me to look into it, and I discovered that this > particular query had the "Print definition?" parameter set to "Yes". I > changed it to "No", and now we're all set. > > Now comes the stumbling block. I'm curious how many other queries have > this parameter set. We have dozens of them, and looking throught them all > one at a time would take a while (besides being boring and IMHO stupid > when I could have the computer do it for me!). Is there a way I can get a > listing (or other form of output) from some command that will tell me > this? I've looked around, and I don't see anything -- I even tried > RTVQMQRY, but that doesn't seem to include this information (or, if it > does, I don't see it). Check the archives for Query ... there was a flurry of very similar interest, in getting *QRYDFN dumped to files that could be analysed, within the last 2 months or so here, leading to a number of links to software tools, one of which I printed out & am transcribing when my time permits. The one I got was at http://hkrebs.dk/fndstrsyso.html Another is at http://archive.midrange.com/repository/extqrydef.htm Also check out http://www.as400network.com/Forums/Main.cfm?CFApp=59 Copy also sent you direct since David's vacation omission means might be a while before we have a hope of being caught up. Perhaps David deserves another vacation as a test that this has been fixed. MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac) AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax interactive & batch) @ http://www.cen-elec.com Central Industries of Indiana--->Quality manufacturer of wire harnesses and electrical sub-assemblies - fax # 812-424-6838 +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.