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

Hold Files

Information can be retrieved and held for further processing in a file called the "hold" file. Subsequent retrievals during the same session can be made from one hold file. This is especially useful for creating a small sub-set against which many reports will be run. It is more economical than running multiple data requests against the entire file. Use the ? HOLD command to see the data elements included in the hold file. 
>
tfs
print ccampus empno cretsys csex age
if campus is BK or SF
on table hold
end

NUMBER OF RECORDS  IN TABLE=        195  LINES=  195

HOLDING ...
>
table file hold
count empno by cretsys across ccampus
end

NUMBER OF RECORDS  IN TABLE=        195  LINES=   195

PAGE    1

          CCAMPUS
            BK   SF
CRETSYS
----------------------
            0    15
N          63    13
P           1     1
U          44    58

>
? hold

DEFINITION OF CURRENT HOLD FILE

FIELDNAME  ALIAS  FORMAT

CAMPUS     E01    A2
EMPNO      E02    A9
CRETSYS    E03    A1
CSEX       E04    A1
AGE        E05    12
Back to Sample Focexecs