Control Statements and Tables › CA JARS Control Statements › GROUPC Statement › Grouping Feature Example 3

Grouping Feature Example 3

Request:

A computer billing report with special rates for each of three account numbers:

AAA   }
BBB   }   different rates for each
CCC   }

Build GROUP and GROUPC statements as follows:

position   1         2         3         4         5                 8
  1........0.........0.........0.........0.........0..            ...0
       points to Accounting Field information
       in Basic Accounting Table

  CGROUP   0773                  <--- select all records

  CGROUPC  1AAA              X   <--- CPU ID for records
                                      with account #AAA

  CGROUPC  1BBB              Y   <--- CPU ID for records
                                      with account #BBB

  CGROUPC  1CCC              Z   <--- CPU ID for records
                                      with account #CCC

Example 3 shows you how to use the grouping feature to dynamically change the CPU identification code in specific accounting records based on their associated account number. This example assumes that the first three characters of the accounting fields information holds an account number.

The selection/rejection indicator is blank, causing all records to be selected since no grouping is required for this report. The CPU identification codes on all qualified records are changed as designated by the GROUPC statements. All unidentified record groups remain unchanged. You could then define separate accounting algorithms on different RATE statements to correspond to the newly created CPU identification codes in addition to other algorithms normally used.