Contact us to schedule a demo or ask a question to learn how AdvantageCS can help you.

Advantage batch processes that use select criteria produce statistics that reflect the number of database records that were a) evaluated and b) selected (or deselected) at each level of the select logic. 

The location of the directory that contains the statistics is environmentally defined by SELECTSTATLOC=<directory>.  Statistics reports are written to that directory if the environment variable is defined and the directory exists.  The default location is a subdirectory of the ProcLogs directory called Select_Stats.   This may be changed by the user.

The process log file contains a message similar to "Selection analysis statistics in <pathname>", so that you may move from a particular log file to its statistics.  Similarly, the actual statistics file identifies the select name that generated it to help tie stats and processes together.

The level of breakdown is according to the structure of the boolean expression, independent of how it is typed in on the select screen.  For example, if a single select screen line at the screen reads:

                AND   CTM.CTM-TYP = 'INDIV' AND CTM.PROMO = 'Y'

the output would break this out as two separate lines in the statistics analysis.

AND   CTM.CTM-TYP = 'INDIV'

AND CTM.PROMO = 'Y'

The indentation used in the analysis reflects the level of detail, with appropriate roll-ups.   For example, the reader can see that a set detail selected 'n' of 'nn' records, but he/she can then examine the indented lines to determine which parts of the complex condition for the set excluded how many customers.

Note that enabling this feature can result in a difference in I/O overhead.  In most cases, this difference is negligible; for major processes, the difference should be small, but you may wish to monitor the impact on processing time.

See below for an example of this output:

Analysis of select set 'PRO305' in process 'PRO305'

Selected

Evaluated

Deselected

Set?

Criteria

16

225

209

001

Select

225

225

0


  ORD.ORD-STA = 'C'

224

225

1


  And ORD.ORD-TYPE IN ('I','G')

16

224

208


  And ORD.CHG-CARD <> ' '

16

16

0


  And VALDSC(ORD.CHG-CARD,'PAY-TYPE') = 'CC'



Filed under: The Molly Minute