Campus Information Retrieval System
Human Resources, Data Operations
When a hold file is created, the data in the resulting file will have the same fieldnames as the fields retrieved from the verb and sort commands.
If you use the AS phrase to rename a field in your request, the name provided appears in the hold file. A set of aliases is also supplied automatically. These aliases are named E01 for the first field, E02 for the second, and so forth. Note: Do not rename your fields to FOCUS commands. For example, COUNT.
For example, the following report request:
TABLE FILE AC
count ac:ssa as ''name'
by AC:BRTHDATE AC:SEX AC:SALARY
IF AC:CBID EQ R03
ON TABLE HOLD AS PERMSML FORMAT LOTUS
Will generate the following master file definition:
DEFINITION OF HOLD FILE: PERMSML
FIELDNAME ALIAS FORMAT
AC:WNAME E01 A39
AC:SALARY E02 P12.2M
Note that only your verb and sort fields are present in the hold file. It will not contain your screened fields.
For more information on hold files refer to your FOCUS documentation.