Re: SQL/QMQRY output question

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Adam

You don't have to do it in Query/400 at all = you can directly use STRQM 
to do everything - it's interface can be very similar to that of 
Query/400 until you change to the SQL style.

Vern

On 10/3/2011 4:04 PM, ADriver@xxxxxxxxxxxx wrote:
> 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.