Sample Report: REPORT IXX

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

Sample Report: REPORT IXX - Type G

Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** 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 Ž

Œ: 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.

Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 1 ******************************************************************************** Directory: PRODCXX 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

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: &bxul.&bxh.&bxh.&bxh.&bxh.&bxh.&bxur. 1st value &bxv.LNAME&bxv.MI FNAME ADDR &bxll.&bxh.&bxh.&bxh.&bxh.&bxh.&bxlr. &bxul.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxur. 2nd value &bxv.LNAME MI&bxv.FNAME ADDR &bxll.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxlr. &bxul.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxur. 3rd value &bxv.LNAME MI FNAME&bxv.ADDR &bxll.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxlr. &bxul.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxur. 4th value &bxv.LNAME MI FNAME ADDR&bxv. &bxll.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxh.&bxlr.

”: 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.