UTILITY command with REDUCE subcommand

This section describes the UTILITY command with the REDUCE subcommand.

Usage

Use the REDUCE subcommand to reduce the volume of data that is input to subsequent subcommands. REDUCE consolidates records with certain common characteristics into one record.

Usage notes

  • REDUCE can be used once in a UTILITY command.

Syntax of the REDUCE subcommand

Read syntax diagramSkip visual syntax diagramREDUCEFROM/TO blockINTERVAL(0minutes)BOUNDARY(60minutes0)INCLUDE/EXCLUDE block

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See Subcommand options for comprehensive descriptions of these options. The following list gives additional or specific descriptions of selected options, where appropriate.

Example using REDUCE with FROM, TO, and INTERVAL options

This example specifies that data is to be reduced between 10:00 a.m. on 4 February 1999 and noon on 5 February 1999. The records are to be reduced into 60-minute intervals.

 
REDUCE
   FROM     (02/04/02,10:00:00.00)
   TO       (02/05/02,12:00)
   INTERVAL (60)