Building the Action Diagram › How to Define Logic for Elementary Processes and Procedures › Add Assignment Actions › Add SUMMARIZE Entity Action › Add Single Entity Views

Add Single Entity Views

You can add single entity views with or without a WHERE clause as discussed in the following examples:

Single Entity View without a WHERE Clause

To determine the total number of employees listed in the database, use a statement similar to the following example:

SUMMARIZE employee 
PLACING count(OCCURRENCES) INTO local ief_supplied count 

Single Entity View with a WHERE Clause

To find the total salaries of all exempt employees, use a statement similar to the following example:

SUMMARIZE employee 
PLACING sum(employee salary) INTO local employee salary 
WHERE DESIRED employee classification = `EX'