Previous Topic: GROUP Statement

Next Topic: Grouping Feature Example 1

The VM Interface › Reporting Component › Report Control Statements › GROUPC Statement

GROUPC Statement

Position

Field Length

Field Name

Notes

1

1

Set Code

Required

2-9

8

Statement Type

GROUPC

10

1

Definition Indicator

1 to 6; relates to a Group Definition on the Group statement

11-18

8

Lower Limiting Criteria*

 

19-26

8

Upper Limiting Criteria*

Optional if same as lower limit

27

1

Group Code

Any character; to be placed in appropriate Group Code field in accounting record

28

1

CPU Identification

any character = replace CPU ID in accounting record with this character

29-80

52

Reserved

Not used

Each Criteria Field is converted to packed-decimal or hexadecimal (binary) or left as is depending on the contents of the appropriate Format Indicator in the GROUP statement.

Refer to the table below to determine the number of characters to code in the Criteria fields (always left justified for Format Indicators P and X):

GROUP Statement Number of Characters for:

Field Length P X

1 1 2

2 3 4

3 5 6

4 7 8

This statement, identified by the statement type GROUPC, is optional. The GROUPC statement must be used in conjunction with the GROUP statement for a given report. Whereas the GROUP statement defines which fields in the accounting record are to be used in the grouping feature, the GROUPC statement supplies the range of values to be used in a compare instruction to qualify the record. Multiple GROUPC statements may be required for a given report in order to provide many value ranges to qualify each accounting record.

The Definition Indicator on the GROUPC statement indicates which definition of the GROUP statement is applicable. Therefore, the Definition Indicator may be 1 to 6, relating to the proper definition number on the GROUP statement.

The Lower and Upper Limiting Criteria on the GROUPC statement provide the actual range of values that are compared against the corresponding value in the accounting record to qualify the record.

The range values must be left justified with trailing blanks when needed. If the Upper Limiting Criteria is the same as the Lower Limiting Criteria, it can be omitted.

The Group Code on the GROUPC statement is a one-character code that is placed in any accounting record that is selected according to the value ranges. The Group Code can subsequently be used as a sort control field via the SORT statement to provide totals for the different groups of accounting records selected by the grouping feature.

Note that positions 296 through 298 and positions 438 through 440 in the Basic Accounting Table correspond to the Group Codes for the six definitions as defined by the Definition Indicator on the GROUPC statement.

The CPU Identification code on the GROUPC statement allows you to dynamically change the CPU Identification of any accounting record for further processing. In this way, qualified records can be assigned different CPU Identification codes corresponding to multiple VMRATE statements for a given report. Identified record groups may then use a different accounting algorithm than other accounting records.

A blank CPU Identification Code on the GROUPC statement indicates that no change in the record CPU Identification is desired.

The examples on the following page show some typical uses and combinations of the GROUP and GROUPC statements.