RE: SQL/QMQRY output question

Next time don't send the entire digest with your response :-)

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT


-----Original Message-----

message: 1
date: Mon, 3 Oct 2011 19:51:55 +0000
from: "ADriver@xxxxxxxxxxxx" <ADriver@xxxxxxxxxxxx>
subject: RE: SQL/QMQRY output question

Hi Everyone,

Thanks for all the responses below. I've used OVRPRTF and it works perfectly. I didn't want to have to create a separate QMFORM for each QMQRY (at least for this exercise), as there are a lot of different reports.....

Anyway, we've developed a RUNSQL tool that allows you to simply input an SQL statement rather than specify a source file member. This uses QMQRY with *SYSDFT as a form behind the scenes, so OVRPRTF worked perfectly.

Again, thanks for all the help.

Adam Driver
IBM Certified Systems Administrator - System i Consultant - Infrastructure Technician Exacta Corporation
608.661.6697 ext 2581
adriver@xxxxxxxxxxxx
Please consider your environmental responsibility before printing this e-mail.