LOCKING command with REDUCE subcommand

This section describes the LOCKING command with the REDUCE subcommand.

Usage

Use the REDUCE subcommand to limit the volume of data that is input to subsequent subcommands.

Usage notes

  • REDUCE consolidates records with certain common characteristics into one record.
  • REDUCE can be used once in a LOCKING command.

Syntax of the REDUCE subcommand

Read syntax diagramSkip visual syntax diagramREDUCEFROM/TO blockINCLUDE/EXCLUDE block

Subcommand options

The syntax diagram shows options available with this subcommand. See Subcommand options for descriptions of each options.

Example using REDUCE with FROM and TO options

This example specifies that data is to be reduced between 10:00 AM on 4 February 2020 and noon on 5 February 2020.

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