QMF Form

If the SQL query shown in Figure 1 is processed using QMF, the data that is returned can be processed into a report. Figure 1 shows a report or forms definition. It creates the report shown in Figure 1 entitled Data Set Profiles With Users Who Are Not Valid in the Access List.

Figure 1. A Sample QMF Form

  COLUMNS:                Total Width of Report Columns: 80
   NUM COLUMN HEADING                         USAGE  INDENT WIDTH EDIT SEQ
   --- -------------------------------------- ------ ------ ----- ---- ---
     1 DSACC_NAME                             BREAK1 2      44    C    1
     2 DSACC_AUTH_ID                                 2      8     C    2
     3 DSACC_ACCESS                                  2      9     C    3
     4 DSACC_ACCESS_CNT                              2      11    L    4



   PAGE:    HEADING  ===> DATA SET PROFILES WITH USERS WHO ARE NOT VALID IN THE 
                          ACCESS LIST
            FOOTING  ===>
   FINAL:   TEXT     ===>
   BREAK1:  NEW PAGE FOR BREAK? ===> NO
            FOOTING  ===>
   BREAK2:  NEW PAGE FOR BREAK? ===> NO
            FOOTING  ===>
   OPTIONS: OUTLINE? ===> YES                   DEFAULT BREAK TEXT? ===> NO