You can refer to an individual field in any one of the following ways:
In the following requests, DEPARTMENT is the complete field name, DPT is the alias, and DEP is a unique truncation of DEPARTMENT. All these examples produce the same output.
1. TABLE FILE EMPLOYEE
PRINT DEPARTMENT
END2. TABLE FILE EMPLOYEE
PRINT DPT
END3. TABLE FILE EMPLOYEE
PRINT DEP
ENDNote: If you use a truncation that is not unique, the following message will appear:
(FOC016) THE TRUNCATED FIELDNAME IS NOT UNIQUE : D
| WebFOCUS |