Example of exporting a report

This example illustrates a report with a level 1 break. Figure 21 shows the report to be exported. For an example of an across report, see ***.

Figure 21. A tabular QMF report

 REPORT                                              LINE 1      POS 1     79
 
                              J & H SUPPLY COMPANY
                       AVERAGE SALARIES (DEPTS 10, 15, 20)
                                    REPORT 17
 
 
                     AVERAGE
     DEPT  JOB       SALARY
   ------  -----  ----------
       10  MGR      20865.86
                  ----------
               *    20865.86
 
       15  CLERK    12383.35
           MGR      20659.80
           SALES    16502.83
                  ----------
               *    15482.33
 
       20  CLERK    13878.68
           MGR      18357.50
           SALES    18171.25
                  ----------
               *    16071.53
 
                  ==========
                    17473.24
 
 
                                  COMPANY NAME
                                    REPORT 17

Figure 22. Format of the exported sample report

H QMF 11 R 01 E V W E R 02 03 98/10/14 11:24
V  1001 006 PERIOD
V  1002 003 016
T  1010 003 006 1013 005 1014 006 1015 006 1016 006 1017 006 1012 008
R  L     000001 000003 000008 000001 BREAK1
R  C     000009 000011 000015 000001 GROUP
R  L2    000016 000018 000027 000001 AVERAGE
L  110 10100000                              J & H SUPPLY COMPANY
L  110 10100000                       AVERAGE SALARIES (DEPTS 10, 15, 20)
L  110 10100000                                    REPORT 17
L  110 10000000
L  110 10000000
L  170 10000000                     AVERAGE
L  170 10000000     DEPT  JOB       SALARY
L  170 10010000   ------  -----  ----------
L  181 11000000       10  MGR      20865.86
L  151 10010000                  ----------
L  151 11100000               *    20865.86
L  151 10000000
L  181 11000000       15  CLERK    12383.35
L  181 11000000           MGR      20659.80
L  181 11000000           SALES    16502.83
L  151 10010000                  ----------
L  151 11100000               *    15482.33
L  151 10000000
L  181 11000000       20  CLERK    13878.67
L  181 11000000           MGR      18357.50
L  181 11000000           SALES    18171.25
L  151 10010000                  ----------
L  151 11100000               *    16071.52
L  151 10000000
L  190 10010000                  ==========
L  190 11000000                    17473.24
L  120 10000000
L  120 10000000
L  120 10100000                                  COMPANY NAME
L  120 10100000                                    REPORT 17
E

When exporting a report, QMF writes the full text of the formatted report with additional information to interpret the contents of the report.

The header record is the first record of the exported file. It is followed by the appropriate V, T, and R records. If the report is an across-style report, it has another group of V, T, and R records that follows the first group.

In addition to H, V, T, R, and E records, exported reports also require two additional types of records:

If you want to use only the formatted data of the report in your application, you can have QMF send print output to a file, data set, or CICS data queue. This file, data set, or CICS data queue contains only the formatted data without any layout information.