REPORT (Generate Reports) › REFGROUP Report › Sample Report: REFGROUP Detail

Sample Report: REFGROUP Detail

This report is similar to the type S report except there is one detail line per REFGROUP. This allows you to see if only certain parts of your data are not well organized by native key within a REFGROUP.

                    CONTROL CARD(S)
 .........1.........2.........3.........4.........5.........6.........7.........8
                      REPORT   REFGROUP=2,DBID=2,TABLE=FLD,TYPE=D
                      FUNCTION=REPORT
                         DBID=00002
                         REFGROUP=00002
                         TABLE=FLD
                         TYPE=D

This page of the report shows the following:

• The command exactly as entered.
• An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
• Any messages related to syntax processing.

                    Table Block Usage Report by Reference Group
  Hex       Rows   Ref      1     2     3     4     5     6     7     8     9   10+   15+   20+   25+   30+   40+   50+
Group  Rows /Blk  Blks    Row  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows
    1    55   27     2      .     .     .     .     .     .     .     .     .     1     .     .     .     .     1
    2    27   13     2      1     .     .     .     .     .     .     .     .     .     .     .     1
    3    20   10     2      .     1     .     .     .     .     .     .     .     .     1
    4    20   10     2      1     .     .     .     .     .     .     .     .     .     1
    5     6    3     2      .     1     .     1
    6    23   11     2      1     .     .     .     .     .     .     .      .     .     .     1
    7     2    1     2      2
    8    41   20     2      .     .     .     .     .     .     .     .     .     1     .     .     .     1
    9    11    5     2      1     .     .     .     .     .     .      .     .     1
    A    79   39     2      .     .     .     .     .     .     .     .     .     .     .     .     .     1     1
    B    42   21     2      .     1     .     .     .     .     .     .     .     .     .     .     .     .     1
    C    81   40     2      .     .     .     .     .     .     .     .     .     .     .     .     .     .     2
    D    15    7     2      1     .     .     .     .     .     .     .     .     1
    E     2    1     2      2
    F    59   29     2      .     .     .     .     .     .     .     .     .     .     .     1     .     1
   10    77   38     2      .     .     .     .     .     .     .     .     .     .     .     .     .     2
   11    78   39     2      .     .     .     .     .     .     .     .     .     .     .     .     .     2
   .
   .
   .
AA743    36   18     2      .     1     .     .     .     .     .     .     .     .     .     .     .     1
AA744    38   19     2      .     1     .     .     .     .     .     .     .     .     .     .     .     1
AA745    35   17     2      1     .     .     .     .     .     .     .     .     .     .     .     .     1

Groups------------------------------------------------Totals ----------------------------------------------------------
698181                609,196      71,784      27,918      17,238      11,804      31,738      27,235       7,293
 12,499,845    8            224,261      41,954      21,943      13,965      43,569      27,540     218,924

This page of the report shows the following:

Hex Group

Displays an ascending counter starting with 1 assigned to each REFRGOUP. It is a hexadecimal number.

Rows

Displays the total number of rows in this REFGROUP.

Rows/Blk

Displays the average rows per block for this REFGROUP.

Ref Blks

Displays the blocks in this REFGROUP. This is the same as the value coded for REFGROUP, except for the last REFGROUP.

1 Row through 50+ Rows

Displays the same explanation as was provided in the TYPE=S REFGROUP report, except that the TYPE=D REFGROUP report is reported for each REFGROUP.

At the end of the TYPE=D REFGROUP report are the totals that summarize the report.

If a table is not defined with compression there is also a line below those shown in the example report. That line, "Maximum Possible Rows per Block," includes a number that can be used to help analyze the values printed for rows and to know how well ordered your data is by REFGROUP.