How to Use

REPORT (Generate Reports) › TYPE=DATANE - Native Sequence Efficiency Report › How to Use

How to Use

To obtain a Native Efficiency report, execute the REPORT function with the following command format:

►►─ REPORT TYPE=DATANE,DBID=dbid,TABLE=table ────────────────────────►
►───┬────────────────────┬┬────────────────┬┬─────────────────────┬──►◄
    └─ ,KEYNAME=keyname ─┘└─ ,NUMBER=nnnn ─┘└─ ,RECORDS=nnnnnnnn ─┘

REPORT

Invokes the report function.

TYPE=

(Required) Requests the Native Efficiency Report.

Valid Entries:: DATANE
Default Value:: (No default)

,DBID=

(Required) Specifies the name of the DBID that you want to use.

Valid Entries:: a valid DBID
Default Value:: (No default)

,TABLE=

(Required) Identifies the table on which you want a report.

Valid Entries:: 3-character DATACOM-NAME of the table in the database specified
Default Value:: (No default)

,KEYNAME=

(Optional) Specifies the key name to use to process the report. The data row sequential efficiency is compared to the order provided by this index.

If a value is not specified, the report uses the Native Key specified for the table.

Valid Entries:: 5-character DATACOM-NAME of the key in the table specified
Default Value:: The Native Key of the selected table

,NUMBER=

(Optional) Specifies the number of data blocks that are read using physical processing (at the beginning of the report execution) to determine the maximum rows per block (MRB). The NUMBER parameter is only honored for data tables that are using compression. For non-compressed tables, the MRB is calculated using the row size and data block size.

Note: Specifying a low value limits the ability to calculate a valid MRB for this table. When the NUMBER parameter is not specified and the data table is compressed, the maximum value (9999 data blocks) is scanned to provide the MRB calculation.

Valid Entries:: 0 to 9999
Default Value:: 9999 (but only used if table is compressed)

,RECORDS=

(Optional) Specifies the rows to process (and include) in a printed group detail line.

If a value is not specified, no detail lines are produced and only the summary lines for the full table are produced.

Note: Specifying a low number for the RECORDS= parameter with a table with many rows generates many detail lines (one per record group). If the number of groups generated exceeds 99,999, the report allows the group number to roll over to zero and begin again. This rollover typically means that over 2000 pages of detail group lines are generated. We recommend that you specify a RECORDS= value that keeps the number of detail groups to 1000 groups or less.

Valid Entries:: 0 to 99999999
Default Value:: (No default)