Creating HOLD Files From FML Reports

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.


Top of page

Example: Creating a Hold File From an FML Report

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

WebFOCUS