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.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of midrange-l-request@xxxxxxxxxxxx
Sent: Friday, September 30, 2011 12:28 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 10, Issue 1361 - answers to SQL question
Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific than "Re: Contents of MIDRANGE-L digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. SQL/QMQRY output question (ADriver@xxxxxxxxxxxx)
2. RE: SQL/QMQRY output question (Schutte, Michael D)
3. Re: SQL/QMQRY output question (Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx)
4. Re: SQL/QMQRY output question (Charles Wilt)
5. Re: SQL/QMQRY output question (Charles Wilt)
6. Re: SQL/QMQRY output question (Luis Rodriguez)
7. Re: SQL/QMQRY output question (Jim Essinger)
----------------------------------------------------------------------
message: 1
date: Fri, 30 Sep 2011 17:04:45 +0000
from: "ADriver@xxxxxxxxxxxx" <ADriver@xxxxxxxxxxxx>
subject: SQL/QMQRY output question
Hi,
I'm trying to set up some audit reports using QMQRY but I'm having some trouble with the output. Using a QMQRY with *SYSDFT as the QMFORM it chops up the output into several spool files, which I don't want. If I try to define a QMFORM it tells me the number of columns must match the number of fields selected, which would mean I would have to create a form for each query. I'm hoping to be able to just create one form and use it for a bunch of queries. Is there any way to do this so it accepts any number of fields/columns but leaves the printed output as one spool file?
BTW, I'm using QMQRY because of an error I can't work out if I use RUNSQLSTM. I get the following error when I try:
5761SS1 V6R1M0 080215 Run SQL Statements AUDSPECAUT 09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
1 SELECT UPUPRF, UPUSCL, UPPWON, UPPSOD, UPTEXT, UPSPAU FROM
2 WEADPD.USRPRFP WHERE UPSPAU <> '*NONE' AND UPUPRF NOT LIKE 'Q%'
* * * * * E N D O F S O U R C E * * * * *
5761SS1 V6R1M0 080215 Run SQL Statements AUDSPECAUT 09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
MSG ID SEV RECORD TEXT
SQL0084 30 1 Position 1 SQL statement not allowed.
As you can see this is a very simple statement and if I just run the same statement from a STRSQL screen it's fine. (I am running the RUNSQLSTM command with *SQL naming too).
Does anyone has any ideas on either the error with RUNSQL or how to fix the output for QMQRY without creating a form for each query?
Thanks in advance
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.
[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.
------------------------------
message: 2
date: Fri, 30 Sep 2011 17:14:35 +0000
from: "Schutte, Michael D" <Michael_Schutte@xxxxxxxxxxxx>
subject: RE: SQL/QMQRY output question
Because there's nothing for it to use to display the results. RUNSQLSTM should be used to create tables, create views, insert, update or delete data. There's probably a lot of other things you can use it for, but select is not one of them.
As for strqmqry, I would imagine that to override the print file.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of ADriver@xxxxxxxxxxxx
Sent: Friday, September 30, 2011 1:05 PM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL/QMQRY output question
Hi,
I'm trying to set up some audit reports using QMQRY but I'm having some trouble with the output. Using a QMQRY with *SYSDFT as the QMFORM it chops up the output into several spool files, which I don't want. If I try to define a QMFORM it tells me the number of columns must match the number of fields selected, which would mean I would have to create a form for each query. I'm hoping to be able to just create one form and use it for a bunch of queries. Is there any way to do this so it accepts any number of fields/columns but leaves the printed output as one spool file?
BTW, I'm using QMQRY because of an error I can't work out if I use RUNSQLSTM. I get the following error when I try:
5761SS1 V6R1M0 080215 Run SQL Statements AUDSPECAUT 09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
1 SELECT UPUPRF, UPUSCL, UPPWON, UPPSOD, UPTEXT, UPSPAU FROM
2 WEADPD.USRPRFP WHERE UPSPAU <> '*NONE' AND UPUPRF NOT LIKE 'Q%'
* * * * * E N D O F S O U R C E * * * * *
5761SS1 V6R1M0 080215 Run SQL Statements AUDSPECAUT 09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
MSG ID SEV RECORD TEXT
SQL0084 30 1 Position 1 SQL statement not allowed.
As you can see this is a very simple statement and if I just run the same statement from a STRSQL screen it's fine. (I am running the RUNSQLSTM command with *SQL naming too).
Does anyone has any ideas on either the error with RUNSQL or how to fix the output for QMQRY without creating a form for each query?
Thanks in advance
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.
[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.
________________________________
Notice from Bob Evans Farms, Inc: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.
------------------------------
message: 3
date: Fri, 30 Sep 2011 12:13:46 -0500
from: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
subject: Re: SQL/QMQRY output question
Stand-alone select statements do not work with RUNSQLSTM...
From: "ADriver@xxxxxxxxxxxx" <ADriver@xxxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 09/30/2011 12:04 PM
Subject: SQL/QMQRY output question
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Hi,
I'm trying to set up some audit reports using QMQRY but I'm having some trouble with the output. Using a QMQRY with *SYSDFT as the QMFORM it chops up the output into several spool files, which I don't want. If I try to define a QMFORM it tells me the number of columns must match the number of fields selected, which would mean I would have to create a form for each query. I'm hoping to be able to just create one form and use it for a bunch of queries. Is there any way to do this so it accepts any number of fields/columns but leaves the printed output as one spool file?
BTW, I'm using QMQRY because of an error I can't work out if I use RUNSQLSTM. I get the following error when I try:
5761SS1 V6R1M0 080215 Run SQL Statements AUDSPECAUT
09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+... 7 ...+... 8 SEQNBR Last change
1 SELECT UPUPRF, UPUSCL, UPPWON, UPPSOD, UPTEXT, UPSPAU FROM
2 WEADPD.USRPRFP WHERE UPSPAU <> '*NONE' AND UPUPRF NOT LIKE 'Q%'
* * * * * E N D O F S O U R C E * * *
* *
5761SS1 V6R1M0 080215 Run SQL Statements AUDSPECAUT
09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+... 7 ...+... 8 SEQNBR Last change
MSG ID SEV RECORD TEXT
SQL0084 30 1 Position 1 SQL statement not allowed.
As you can see this is a very simple statement and if I just run the same statement from a STRSQL screen it's fine. (I am running the RUNSQLSTM command with *SQL naming too).
Does anyone has any ideas on either the error with RUNSQL or how to fix the output for QMQRY without creating a form for each query?
Thanks in advance
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.
[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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 4
date: Fri, 30 Sep 2011 13:18:58 -0400
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: SQL/QMQRY output question
QMQRY is the right tool...
RUNSQLSTMT isn't.
*SYSDFT is fine, if that meets your needs.
Try OVRPRTF FILE(QPQXPRTF) PAGESIZE(132 66 *ROWCOL) LPI(6) CPI(10)
Or whatever you need to fit the results in the width... the default is only 80 columns...
HTH,
Charles
On Fri, Sep 30, 2011 at 1:04 PM, ADriver@xxxxxxxxxxxx <ADriver@xxxxxxxxxxxx> wrote:
Hi,
I'm trying to set up some audit reports using QMQRY but I'm having some trouble with the output. Using a QMQRY with *SYSDFT as the QMFORM it chops up the output into several spool files, which I don't want. If I try to define a QMFORM it tells me the number of columns must match the number of fields selected, which would mean I would have to create a form for each query. I'm hoping to be able to just create one form and use it for a bunch of queries. Is there any way to do this so it accepts any number of fields/columns but leaves the printed output as one spool file?
BTW, I'm using QMQRY because of an error I can't work out if I use RUNSQLSTM. I get the following error when I try:
5761SS1 V6R1M0 080215 ? ? ? ? ? ? ? Run SQL Statements ? ? ? ? ? ?
AUDSPECAUT ? ? ? ? ? ? ? ? ? ? ? ? 09/30/11 11:47:44 ? PAGE Record
?*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+...
7 ...+... 8 ? SEQNBR ?Last change ? ? ?1 SELECT UPUPRF, UPUSCL, UPPWON, UPPSOD, UPTEXT, UPSPAU FROM ? ? ?2 WEADPD.USRPRFP WHERE UPSPAU <> '*NONE' AND UPUPRF NOT LIKE 'Q%'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? * * * * * ?E N D ?O F ?S O U R C E ?*
* * * *
5761SS1 V6R1M0 080215 ? ? ? ? ? ? ? Run SQL Statements ? ? ? ? ? ?
AUDSPECAUT ? ? ? ? ? ? ? ? ? ? ? ? 09/30/11 11:47:44 ? PAGE Record
?*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+...
7 ...+... 8 ? SEQNBR ?Last change MSG ID ?SEV ?RECORD ?TEXT
SQL0084 ?30 ? ? ? 1 ?Position 1 SQL statement not allowed.
As you can see this is a very simple statement and if I just run the same statement from a STRSQL screen it's fine. (I am running the RUNSQLSTM command with *SQL naming too).
Does anyone has any ideas on either the error with RUNSQL or how to fix the output for QMQRY without creating a form for each query?
Thanks in advance
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.
[Like us on
Facebook!]<http://www.facebook.com/#!/pages/WEA-Insurance-Trust/199543
713420728>
- 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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 5
date: Fri, 30 Sep 2011 13:23:27 -0400
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: SQL/QMQRY output question
Oh and I must say, I've never used *SYSDFT for anything but qucik and dirty output for myself.
For any production report, I create a QMFORM...it's not that hard..
Charles
On Fri, Sep 30, 2011 at 1:18 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
QMQRY is the right tool...
RUNSQLSTMT isn't.
*SYSDFT is fine, if that meets your needs.
Try OVRPRTF FILE(QPQXPRTF) PAGESIZE(132 66 *ROWCOL) LPI(6) CPI(10)
Or whatever you need to fit the results in the width... the default is
only 80 columns...
HTH,
Charles
On Fri, Sep 30, 2011 at 1:04 PM, ADriver@xxxxxxxxxxxx
<ADriver@xxxxxxxxxxxx> wrote:
Hi,
I'm trying to set up some audit reports using QMQRY but I'm having some trouble with the output. Using a QMQRY with *SYSDFT as the QMFORM it chops up the output into several spool files, which I don't want. If I try to define a QMFORM it tells me the number of columns must match the number of fields selected, which would mean I would have to create a form for each query. I'm hoping to be able to just create one form and use it for a bunch of queries. Is there any way to do this so it accepts any number of fields/columns but leaves the printed output as one spool file?
BTW, I'm using QMQRY because of an error I can't work out if I use RUNSQLSTM. I get the following error when I try:
5761SS1 V6R1M0 080215 ? ? ? ? ? ? ? Run SQL Statements ? ? ? ? ? ?
AUDSPECAUT ? ? ? ? ? ? ? ? ? ? ? ? 09/30/11 11:47:44 ? PAGE Record
?*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+...
7 ...+... 8 ? SEQNBR ?Last change ? ? ?1 SELECT UPUPRF, UPUSCL, UPPWON, UPPSOD, UPTEXT, UPSPAU FROM ? ? ?2 WEADPD.USRPRFP WHERE UPSPAU <> '*NONE' AND UPUPRF NOT LIKE 'Q%'
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? * * * * * ?E N D ?O F ?S O U R C E ?*
* * * *
5761SS1 V6R1M0 080215 ? ? ? ? ? ? ? Run SQL Statements ? ? ? ? ? ?
AUDSPECAUT ? ? ? ? ? ? ? ? ? ? ? ? 09/30/11 11:47:44 ? PAGE Record
?*...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+...
7 ...+... 8 ? SEQNBR ?Last change MSG ID ?SEV ?RECORD ?TEXT
SQL0084 ?30 ? ? ? 1 ?Position 1 SQL statement not allowed.
As you can see this is a very simple statement and if I just run the same statement from a STRSQL screen it's fine. (I am running the RUNSQLSTM command with *SQL naming too).
Does anyone has any ideas on either the error with RUNSQL or how to fix the output for QMQRY without creating a form for each query?
Thanks in advance
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.
[Like us on
Facebook!]<http://www.facebook.com/#!/pages/WEA-Insurance-Trust/19954
3713420728>
- 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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 6
date: Fri, 30 Sep 2011 12:57:19 -0430
from: Luis Rodriguez <luisro58@xxxxxxxxx>
subject: Re: SQL/QMQRY output question
Adam,
Do a OVRTPRTF with the appropiate length. Something like:
OVRPRTF FILE(*PRTF) PAGESIZE(*N 180) CPI(15) +
HOLD(*YES) OVRSCOPE(*JOB)
HTH,
Luis Rodriguez
IBM Certified Systems Expert ? eServer i5 iSeries
--
On Fri, Sep 30, 2011 at 12:34 PM, ADriver@xxxxxxxxxxxx <ADriver@xxxxxxxxxxxx
wrote:
Hi,
I'm trying to set up some audit reports using QMQRY but I'm having
some trouble with the output. Using a QMQRY with *SYSDFT as the QMFORM
it chops up the output into several spool files, which I don't want.
If I try to define a QMFORM it tells me the number of columns must
match the number of fields selected, which would mean I would have to
create a form for each query. I'm hoping to be able to just create one
form and use it for a bunch of queries. Is there any way to do this so
it accepts any number of fields/columns but leaves the printed output as one spool file?
BTW, I'm using QMQRY because of an error I can't work out if I use
RUNSQLSTM. I get the following error when I try:
5761SS1 V6R1M0 080215 Run SQL Statements
AUDSPECAUT 09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+... 7 ...+... 8 SEQNBR Last change
1 SELECT UPUPRF, UPUSCL, UPPWON, UPPSOD, UPTEXT, UPSPAU FROM
2 WEADPD.USRPRFP WHERE UPSPAU <> '*NONE' AND UPUPRF NOT LIKE 'Q%'
* * * * * E N D O F S O U R C E *
* * *
*
5761SS1 V6R1M0 080215 Run SQL Statements
AUDSPECAUT 09/30/11 11:47:44 PAGE
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+... 7 ...+... 8 SEQNBR Last change
MSG ID SEV RECORD TEXT
SQL0084 30 1 Position 1 SQL statement not allowed.
As you can see this is a very simple statement and if I just run the
same statement from a STRSQL screen it's fine. (I am running the
RUNSQLSTM command with *SQL naming too).
Does anyone has any ideas on either the error with RUNSQL or how to
fix the output for QMQRY without creating a form for each query?
Thanks in advance
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.
[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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
------------------------------
message: 7
date: Fri, 30 Sep 2011 12:00:57 -0600
from: Jim Essinger <dilbernator@xxxxxxxxx>
subject: Re: SQL/QMQRY output question
As others have advised, QMQRY is the tool for reports. As for the number of columns matching, I start with the query and create the output I want, then run it at least once, saving the output from the F5 or F6 when you get it right. Then I use F13 to work on the form, selecting column width, summary options, level breaks, etc. From there I save both the form and qry with the same name, and use STRQMQRY to run the query, after doing an override if needed for reports wider than 80 columns. FYI you can pass parms with the STRQMQRY command which makes it nice to produce specific reports from a more generic query.
HTH
Jim
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
End of MIDRANGE-L Digest, Vol 10, Issue 1361
********************************************
midrange.com
