S A M P L E   F O C E X E C S

Unduplicated List

When producing a list of employees, each employee will appear as many times as he has records at the level fo the file selected.

The following report is duplicated at the distribution level because each employee appears as often as he has distributions. Duplication always occurs in an alternate file view based on a data element below the employee level. 

>
cx-tuc
print empname ctitle monfte
if recordlimit is 10
end

NUMBER OF RECORDS IN TABLE=       10   LINES=     10

PAGE     1

EMPNAME             CTITLE  MONFTE
-------             ------  ------
BERLING,MARILYN M   5007     .2500
BERLING,MARILYN M   5007     .2500
BERLING,MARILYN M   5007     .0272
BERLING,MARILYN M   5007     .0272
BERLING,MARILYN M   5007     .5000
BANKS,KENNETH F     487L,    .3587
ANDRADE,MARIA R     4612    1.0000
ALBA,RAYMOND C      6762     .1427
ALBA,RAYMOND C      4673     .4117
AGLEHAM,LOURDES F   4723    1.0000
The following report is duplicated at the title level. The employee appears as often as he has titles. 
>
cx-tuc
sum monfte by empname by ctitle
if recordlimit  is  10
end

NUMBER OF RECORDS  IN TABLE=        10    LINES=     6

PAGE 1

EMPNAME                CTITLE  MONFTE
-------                ------  ------
AGLEHAM,LOURDES F      4723    1.0000
ALBA,RAYMOND C         4673     .4117
                       6762     .1427
ANDRADE,MARIA R        4612    1.0000
BANKS,KENNETH F        4874     .3587
BERLING,MARILYN M      5007    1.0544
The following report is unduplicated at the employee level. Each employee appears only once. The gross pays have been summed. The last title for each employee has been selected (since alpha-numeric fields cannot be summed). 
     cx-tuc
     sum monfte ctitle by empname
     if recordlimit is 10
     end

     NUMBER OF RECORDS IN TABLE=     10   LINES=      5

     PAGE 1

     EMPNAME                CTITLE   MONFTE
     -------                ------   ------
     AGLEHAM,LOURDES F      4723     1.0000
     ALBA,RAYMOND C         6762      .5544
     ANDRADE,MARIA R        4612     1.0000
     BANKS,KENNETH F        4874      .3587
     BERLING,MARILYN M      5007     1.0544
Back to Sample Focexecs