The FOCUS command SEGMENT can be used to retrieve all fields in a segment by only specifying one field - any field - in the segment. This command is particularly useful if you are downloading many data elements. For example, if you want to download all the fields from the active (personnal data) segment of the Active Current Status file, execute the following commands:
EX AC
TABLE FILE AC
PRINT SEGMENT AC:SSA
ON TABLE HOLD AS PERMLRG FORMAT LOTUS
END
Note: The SEGMENT command will only retrieve UNDEFINED fields. If you would like to print defined fields (indicated by an * in the master file description) you must specify the fieldname in the report request. For example:
EX AC
TABLE FILE AC
PRINT SEGMENT AC:SSA AC:ETHNICGRP AC:DAO
ON TABLE HOLD AS PERMLRG FORMAT LOTUS
END
Last Updated: February 27, 2024