Adding a SUMMARIZE entity action is part of creating entity actions in the Action Diagram. This statement lets you summarize all selected occurrences of a set of entities consisting of one or more related entity types.
The SUMMARIZE action statement must be in the following format:
SUMMARIZE entity-view-list PLACING aggregate function INTO attribute-view
Contains the same views eligible for READ or READ EACH statements
References an aggregate function and designates a modifiable attribute view to receive the results. The attribute-view is transient and modifiable.
The SUMMARIZE statement supports the use of all ANSI standard SQL aggregate functions such as COUNT, MAX, MIN, AVERAGE, and SUM to be used to derive values from a specified collection of entities. The SUMMARIZE statement is used to retrieve a single composite value for each aggregate function specified. It is similar to READ except that one or more PLACING clauses are required, in which modifiable attribute views of the appropriate domain are designated to receive each aggregate value.
The SUMMARIZE statement reviews all selected occurrences of a set of entities consisting of one entity type or multiple related entity types, and retrieves aggregate values from the database using one or more of the following aggregate functions:
|
Copyright © 2014 CA.
All rights reserved.
|
|