Defined fields are typically part of report requests, but they can also be stored by themselves in a separate procedure to simplify maintenance, and to share with other users. If stored separately, there are two ways to incorporate defines into other report requests: using the EXECUTE or -INCLUDE command.
The EXECUTE command (EX) can be used to incorporate a fully executable procedure. For example, if you have a report request named 'MYDEFINE' that contains the commands to begin and end the define for your campus departments, you could execute that procedure in another report request named 'REPORT1'.
DEFINE FILE ac add
DEPT/A15=IF AC:agyunit eq '999100' then 'Business' else
if ac:agyunit eq '999200' then 'anthro' else
if ac:agyunit eq '999300' then 'admin' else '?';
TABLE FILE AC
-* note: dept is created per mydefine
The -INCLUDE command can be used to incorporate a partial procedure that can not be executed alone. For example, if you have a report request named 'MYDEFINE' that contains only the fieldname and expression to define your campus departments, you could include that procedure in another report request named 'REPORT1'.
Refer to your FOCUS documentation for complete information on the EXECUTE and -INCLUDE commands.
Last Updated: June 02, 2003