Report output

Figure 1 shows the report that results from the SQL query shown in Figure 1 and the QMF™ form shown in Figure 1. Not all of the resulting rows are shown.

Figure 1. A sample report

DATA SET PROFILES WITH ACCESS LISTS CONTAINING USER IDS OR GROUP
NAMES THAT ARE NOT VALID

DSACC_NAME                       DSACC_AUT DSACC_ACC DSACC_ACCES
-------------------------------- --------  --------- -----------
JAS.WORK.CNTL                    WILLIEC   READ                3
                                 JEFFK     READ                2
                                 LIEN      READ                2
                                 DIANEB    READ                4
                                 SLICK     READ                5
                                 KOFI      READ                2
                                 CHUCKY    READ                1
                                 AERON     READ                2
                                 LING      READ                3
                                 TONYL     READ                3
                                 JOES      READ                6

SINEAD.DOC.TEXT                  SIMONE    READ                4
                                 HAN       READ                2

FRANTI.TEST.DATA                 MIKEF     READ               10

MARLEY.DESIGNS.DATA              ZIGS      READ                3

HUMAN.*                          FATIMA    UPDATE              6
                                 STING     READ                1



04/31/2004 04:26 PM                                        PAGE 10