REPORT (Generate Reports) › Index Area (IXX) Reports › Sample Report: REPORT IXX - Type G

Sample Report: REPORT IXX - Type G

                    CONTROL CARD(S)
                    .........1.........2.........3.........4.........5.........6.........7.........8
                    REPORT  AREA=IXX,DBID=1,TYPE=G,UPDATE=YES
 
                    FUNCTION=REPORT
                       AREA=IXX
                       DBID=1
                       UPDATE=YES
                       TYPE=G
 
         

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.

                    INDEX  POPULATION  REPORT  -  BY TABLE
 
 
                                                         TOTAL          UNIQUE
                    TABLE    KEY ID     KEY NAME       RECORDS         RECORDS        DATE/TIME         COMMENTS
 
 
                    PAY        001       EMPNO             200                   5/25/2003,09.15.44
                                                                           200
                    PMF        001       EMPNO             200                   5/25/2003,09.15.48
                                                                           200
                               002       STZIP             200                   5/25/2003,09.15.48
                                                                             6
                                                                             8
                    PNC        016       PNDAT               5                   5/25/2003,09.15.51
                                                                             3
                                                                             5
                    PNM        015       PN                  3                   5/25/2003,09.15.51
                                                                             3
                    POH        011       POLI                5                   5/25/2003,09.15.51
                                                                             5
                                                                             5
                               012       VENDR               5                   5/25/2003,09.15.51
                                                                             3
                               013       POHTV               5                   5/25/2003,09.15.51
                                                                             4
                               014       LATE                2                   5/25/2003,09.15.51
                                                                             1
 
                    POL        011       POLI                4                   5/25/2003,09.15.51
                                                                             3
                                                                             4
                               015       PN                  4                   5/25/2003,09.15.51
                                                                             3

This page of the report displays the following information:

TABLE

The DATACOM-NAME of the table.

KEY ID

The DATACOM-ID of the key.

KEY NAME

The DATACOM-NAME of the key.

TOTAL RECORDS

Number of records indexed by this key at LOAD time, RETIX time, or currently, if UPDATE=YES is specified.

UNIQUE RECORDS

Number of records with distinct values for this key field or key field combination. The first value given is the number of records with distinct values for the high-order key field. The next value given is the number of records with distinct values for the high-order key field and the adjacent key field and so on until the last value, which gives the number of records with distinct values for the entire key (all fields).

For example, if you have a key named NAMEADDR made up of fields: LNAME, MI, FNAME, and ADDR, the key statistics would be reported as follows:

Value Reported    Records With Distinct Values for:
                  ┌─────┐
  1st value       │LNAME│MI FNAME ADDR
                  └─────┘

                  ┌────────┐
  2nd value       │LNAME MI│FNAME ADDR
                  └────────┘

                  ┌──────────────┐
  3rd value       │LNAME MI FNAME│ADDR
                  └──────────────┘

                  ┌───────────────────┐
  4th value       │LNAME MI FNAME ADDR│
                  └───────────────────┘

DATE/TIME

Date and time of the LOAD or RETIX when this data was compiled, or the date and time that this report was executed, if UPDATE=YES is specified.

COMMENTS

If the Index for this table is not loaded, a comment is displayed.

If the key ID is duplicated within one table, a comment is displayed. In this case, the total Index entries for the key ID are reported with the first key name with that ID. The second (and any others) show a zero count.