Hi Pete,
Thanks, that's good to know for the future! In this case I already have all the SQL statements defined so I don't really want to spend the time recreating all of that in Query400.
Thanks
Adam Driver
IBM Certified Systems Administrator - System i
Consultant - Infrastructure Technician
Exacta Corporation
608.661.6697 ext 2581
adriver@xxxxxxxxxxxx<mailto:adriver@xxxxxxxxxxxx>
Please consider your environmental responsibility before printing this e-mail.
date: Sun, 2 Oct 2011 16:51:41 +0000 (UTC)
from: Pete Hall <pete@xxxxxxxxxxxxxx<mailto:pete@xxxxxxxxxxxxxx>>
subject: Re: SQL/QMQRY output question
Way back, I used to use Query400 (the green screen version) to create the report output I was looking for. Query400 created a query object, then I used CRTQMQRY and CRTQMFORM to extract the SQL and form information from the query object. The resulting source could then be modified as needed, and the RUNQMQRY command (I think that was it) allowed specifying parameters too, which was what made it really useful for simple reports.
That was 20 years ago or so, but I'd guess it would still work if you had
Query400 installed. Is that still available?
--
Pete Hall
pete@xxxxxxxxxxxxxx<mailto:pete@xxxxxxxxxxxxxx>
[Like us on Facebook!]<
http://www.facebook.com/#!/pages/WEA-Insurance-Trust/199543713420728>
- WEA Trust Confidentiality Notice -
This electronic mail message and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Dissemination, forwarding, printing, or copying of this electronic mail without the consent of the sender is strictly prohibited. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error; please immediately notify the sender by return mail.
midrange.com
