A report created with FML can be extracted to a HOLD file in the same way as all other reports created with the TABLE language.
In this case, you identify the set of tag values specified for each row by the description field (the AS text supplied in the model). When no text is given for a row, the first tag value is used automatically. Therefore, in simple models with only one tag per row and no text, the lines in the HOLD file contain the single tag value. The rows derived from the RECAP calculation form part of the HOLD file. Pure text rows (including BAR rows) are omitted.
For HOLD to be supported with RECAP, the format of the RECAP field must be the same as the format of the original column.
This feature enables you to create new rows in the HOLD file that are the result of calculations. The augmented HOLD file may then be used in a variety of TABLE requests.
Note: You cannot reformat RECAP rows when creating HOLD files.
The following request creates a HOLD file that contains records for CASH, ACCOUNTS RECEIVABLE, INVENTORY, and the RECAP row CURRENT ASSETS.
TABLE FILE LEDGER SUM AMOUNT FOR ACCOUNT 1010 TO 1030 AS 'CASH' OVER 1100 AS 'ACCOUNTS RECEIVABLE' OVER 1200 AS 'INVENTORY' OVER RECAP CA = R1 + R2 + R3; AS 'CURRENT ASSETS' ON TABLE HOLD END
Query the HOLD file:
> ? hold DEFINITION OF HOLD FILE: HOLD FIELDNAME ALIAS FORMAT EO1 A 19 AMOUNT EO2 I5C
Then report from the HOLD file as:
TABLE FILE HOLD PRINT E01 E02 END
The output is shown in the following image.
AMOUNT ------ CASH 21,239 ACCOUNTS RECEIVABLE 18,829 INVENTORY 27,307 CURRENT ASSETS 67,375