Re: Query to QMQRY help...

["sjl" <sjl_abc@xxxxxxxxxxx>]

Vern -
I'm not sure if it part of the base OS, but if the STRQM command works, you 
basically have all of the essentials for QMF on your system.
- sjl


"Vernon Hamberg"  wrote in message 
news:mailman.11803.1343153903.2513.midrange-l@xxxxxxxxxxxx...

Steve

Is QMF free? I thought it used to be. Have never tried it myself.

Vern

On 7/24/2012 12:09 PM, sjl wrote:
> Tom -
>
> QMF is a cross-platform product.  perhaps this will help:
>
> http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.qmf10.doc.using%2Fqmf10using.htm
>
> - sjl
>
>
> "Tom Hightower"  wrote in message
> news:mailman.11775.1343148740.2513.midrange-l@xxxxxxxxxxxx...
>
> I've retrieved the QMFORM source, compiled the source as a form, and run 
> the
> STRQMQRY to get the report results to a file - sill no BREAKLVL or 
> OVERFLOW
> fields in my output file.
>
> Do you know of a link to the manual?
>
> Thanks,
> TomH
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
> Sent: Friday, July 20, 2012 2:54 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Query to QMQRY help...
>
> Tom,
> there is a QM Form component that just might get you there - but you will
> need to go to the manual and do a little self-help.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Hightower
> Sent: Friday, July 20, 2012 1:51 PM
> To: Midrange Systems Technical Discussion
> Subject: Query to QMQRY help...
>
> I have a query which uses as input one file, summarizes a single amount
> field with a break level by dept#, and a final total:
>
> CRLOCATN CRAMOUNT
>     397
>      TOTAL 67,885.83
>
>     399
>      TOTAL 90,068.23
>
>      FINAL TOTALS
>      TOTAL 157,954.06
>
>
> The *outfile for this is:
> *...+....1....+....
> 1 39700000006788583
> 1 39900000009006823
> 0 00000000015795406
>
> Field 1: BreakLvl, pos 1-1
> Field 2: Overflow, pos 2-2
> Field 3: Dept#, pos 3-5
> Field 4: CRAMOUNT01, pos 6-19
>
> If I do a RTVQMQRY to extract the query statements into an SQL source 
> file,
> I get this:
>
> H QM4 05 Q 01 E V W E R 01 03 12/07/20 14:39
> V 1001 050 to pull voided checks to add back for AP
> V 5001 004 *HEX
> SELECT
>    ALL       CRLOCATN, (CRAMOUNT)
>    FROM      WORKFILE T01
>    WHERE     CRSTATUS = 1
>      AND     CRCASHCN*10000.+CRCASHYR*100.+CRCASHMO =
>              YEAR(CURRENT DATE-1 MONTH)*100.+MONTH(CURRENT DATE-1 MONTH)
>      AND     CRWRITCN*10000.+CRWRITYR*100.+CRWRITMO <>
>              YEAR(CURRENT DATE-1 MONTH)*100.+MONTH(CURRENT DATE-1 MONTH)
>    ORDER BY  001 ASC
>
>
> Some stuff is missing there, and I can fix it up so that it's like so:
> H QM4 05 Q 01 E V W E R 01 03 12/07/20 14:39
> V 1001 050 to pull voided checks to add back for AP
> V 5001 004 *HEX
> SELECT
>    ALL       ' ' AS BREAKLVL, ' ' AS OVERFLOW, CRLOCATN, SUM (CRAMOUNT)
>
>    FROM      WORKFILE T01
>    WHERE     CRSTATUS = 1
>      AND     CRCASHCN*10000.+CRCASHYR*100.+CRCASHMO =
>              YEAR(CURRENT DATE-1 MONTH)*100.+MONTH(CURRENT DATE-1 MONTH)
>      AND     CRWRITCN*10000.+CRWRITYR*100.+CRWRITMO <>
>              YEAR(CURRENT DATE-1 MONTH)*100.+MONTH(CURRENT DATE-1 MONTH)
> GROUP BY CRLOCATN
>    ORDER BY  001 ASC
>
>
> Which, when run, the QMQRY gives this file:
> *...+....1....+....
>    39700000006788583
>    39900000009006823
>
> Note that the breaklvl is blank, and there is no final total line in the
> file (or on display if I run the query that way).  How do I get the output
> of the QMQRY file to be the same as the output of the STRQRY file?
>
> TomH
>
> --
> 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.
>
>
>
> --
> 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.